2 ways to create a Dropdown from another File in Google Sheets
HTML-код
- Опубликовано: 24 авг 2024
- In this tip, we will learn two ways to create a dropdown with data from another Google Sheets file.
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheet...
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: practicalsheet...
➤Webpage: practicalsheet...
➤Newsletter: practicalsheet...
➤Telegram: practicalsheet...
➤Facebook: practicalsheet...
➤Twitter: practicalsheet...
Any suggestion, question or insights, feel free to comment below
Error
The data validation rule has more items than the limit of 500. Use the "List from a range" criteria instead.
You are right!
But, unfortunately, "List from a range" only accepts ranges present on a current file. It won´t work in this case
Kind Regards,
If I convert the dropdown menu to the a google table, is there a way to automatically format the text background and font colors?
Hmmm
Right now, I wouldn't know how to, but will look into it
Kind Regards
@@practicalsheets TY
Thanks a lot🫀! I think this was a super helpful tutorial👏!!
Thanks for the comments!
Is there a way for dropdown menus to keep any hyperlinks attached to the aux text being used?
Unfortunately not in Sheets. Hopefully in the future
Kind Regards
Is it possible to add a filter to this script? if so, can you demonstrate or share the amended script?