2 ways to create a Dropdown from another File in Google Sheets

[@thib4855]

You're a legend.
That's exactly what I was looking for.
Thanks!

[@practicalsheets]

Thanks for the kind words!

[@vivekkaushal8691]

Error
The data validation rule has more items than the limit of 500. Use the "List from a range" criteria instead.

[@practicalsheets]

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,

[@FuzzyDreamin]

Is there a way for dropdown menus to keep any hyperlinks attached to the aux text being used?

[@practicalsheets]

Unfortunately not in Sheets. Hopefully in the future
Kind Regards

[@sqgrowthconnect]

Is it possible to add a filter to this script? if so, can you demonstrate or share the amended script?

[@MarisaArnoldDLS]

If I convert the dropdown menu to the a google table, is there a way to automatically format the text background and font colors?

[@practicalsheets]

Hmmm
Right now, I wouldn't know how to, but will look into it
Kind Regards

[@MarisaArnoldDLS]

@@practicalsheets TY

[@plamenyankov8476]

Thanks a lot🫀! I think this was a super helpful tutorial👏!!

[@practicalsheets]

Thanks for the comments!