Google Docs Drop Down List - New Feature!

[@raniahamzeh6483]

Awesome Video, Thank you for sharing.

[@saperis]

Thanks for watching! 😀

[@cttrumann8961]

Very useful, thanks! I got notified that this feature was available but wasn't sure what it was for, now I understand.

[@saperis]

Glad it was helpful! 😀

[@cttrumann8961]

@@saperis It's really revolutionized my event organizing spreadsheets, hahaha!

[@xaquison]

Thanks for the explanation of this new feature. Definitely worthwhile knowing.

[@saperis]

Glad it was helpful! 👍

[@MrGaryparker]

I see this being very useful when you need specific terms used for a database application. Random entries would need to be cleaned up. This would prevent that.

[@saperis]

Thanks for sharing that use case. 👍

[@supportchannel4720]

New sub

[@saperis]

Welcome aboard! 😀

[@tonyghee2911]

How would you set it up to delete from one sheet and apply it to another? Like the video you wanted to have the first tab as "Active Projects" and within the drop down menu when you select "Complete" it will delete from "Active Projects" and move it to another tab called "Completed Tasks" so that you can keep track.

[@saperis]

There is currently no such automatic feature. But, if you know Google Apps Script, you could in theory create such an automation.

[@debc7219]

Is there a way to preserve the drop down lists when creating a copy of the document?

[@saperis]

If I'm not mistaken that's what happens whenever you copy a document.

[@tomreine4121]

@@saperis Hey, when I make a copy, the drop down menu disappears. Do you have a fix for that?

[@saperis]

@@tomreine4121 Interesting, didn't know this feature behaves that way. Don't have a solution for that.

[@pattsotsos]

Can you paste a list of items for a drop down instead of adding each item separately?

[@saperis]

You can create a dropdown list from already existing data. See how it's done: support.google.com/docs/answer/186103?hl=en&co=GENIE.Platform%3DDesktop

[@pattsotsos]

Thank you!

[@Leover378]

No conocía esa útil función.

[@saperis]

😀

[@mirandabarajas1845]

When I "copy" the document, the drop down menu goes away! HELP!

[@saperis]

In what sense do you "copy" the document? Do you copy it in Google Drive? Or are you referring to copy & pasting the content of the document?

[@tomreine4121]

@@saperis When making a copy din Google Drive. Same happens here.