Google Sheets Hack: Select Multiple Items in Google Sheets

Опубликовано: 21 Октябрь 2024
на канале: Sheets Ninja

509

Tired of getting told "You can't do that!" every time you want to be able to select multiple items in a dropdown in Google Sheets? In this video, I reveal a hack to accomplish this using a simple Apps Script script with everything you need to know about setting it up in Google Sheets along with tips & tricks for the script to make this script only work where and when you want it to.

You can make a copy of the final template here: https://bit.ly/47drxp3

You can check out a quick walkthrough of the new multi-select functionality Google just added in this video: • How to Add Multiple Selection Dropdow...

You can also check out our more sophisticated tutorial on how to do this with a sidebar and checkboxes here: • Select Multiple Items in Sidebar: Goo...

0:00 Intro
0:24 Setting up Dropdowns
0:58 Basic Script
3:40 First Demo
4:16 More Script Options
10:50 Conclusion