Select Multiple Items in Sidebar: Google Sheets / Apps Script Full Tutorial
Do you need to be able to select multiple items in dropdowns in Google Sheets but have been endlessly frustrated by the lack of capability to do so? No longer, using this slick, streamlined sidebar interface that allows you to pull the dropdown options from a cell (including any currently selected options), and add or update the selections with a click of a button.
You can make a copy of the final Google Sheets + Script here: https://bit.ly/4ge2Vk2
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...
If you're looking for another option without using chips, check out our onEdit script hack here: • Google Sheets Hack: Select Multiple I...
0:00 Introduction
0:40 Setting up the Dropdown
1:10 Initial Script & HTML Setup
2:25 GAS - Menu
3:18 GAS - Show Sidebar
4:35 GAS - Retrieve Dropdown Options & Selected Items
8:43 GAS - Add Selected Options to Google Sheet
10:09 HTML - Setup & Buttons
14:00 JS - Basic Setup
18:45 JS - Populate Sidebar - Retrieve Options & Selected
29:52 JS - Add Selected Options to Sheet
34:57 JS - Refresh Dropdown Options
35:39 Authorize Script
36:46 Initial Test & Troubleshooting
44:01 Final Dropdown Options Note
44:52 Conclusion
![Easy Automatic Last Updated Timestamp in Google Sheets [No Authorization Required]](https://images.videosashka.com/watch/i-qd8vXUoEA)
