Answer the question
In order to leave comments, you need to log in
How to make a dropdown list in Google spreadsheet that links to another document?
I want to make a dropdown list, the values of which will be in another document. Now I use the variant with the importrange () function. That is, I pull the data from the second dox into the first one on a separate sheet, and already make a drop-down list from it.
Is there an option to get rid of this intermediate sheet and take data immediately from the second dox?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question