Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Add value in dropdown list linked to an external sheet

Hi, I’m stuck with a new problem
It there a way to show a dropdown list linked to a google sheet document and be able to add values to this list when a new value is written ?
I tried data validity but did not work.
I tried ref / rel but it shows me a warning next to each item

(i have several dropdown lists to show, and for the moment i created one unique sheet with all the lists ; there are also associated values or descriptions for some items from the list )

Thank you !!

Solved Solved
0 8 879
1 ACCEPTED SOLUTION

Ok I managed to do it by using a reference table and i had to do one list per table in google sheets

View solution in original post

8 REPLIES 8
Top Labels in this Space