I'm using Google Docs to collect a lot of information about property. Each property has its own Doc file. In this Doc, I have various Dropdown lists. I'm at the point where I need to update and add options to some Dropdown Lists. However, the problem is I would need to go into each Doc separately and update each list manually.

Q: - Is there a way to have a global dynamic Dropdown List that I can on every Doc?

In attempt to achieve this, I created a Google Sheet and in Column A added all the contents of one particular list. However, I'm unsure how to add Data Validation in Google Docs to use the cell range to create a dropdown list.

Can I create a Dropdown List in google sheets and use the range in various Google Documents, or is there a better solution?



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.