Multiple Selection Data Validation in Google Sheets

Got Sheet? Link below...👇 Review of a couple updates to the UI since original publication: How to add a script and html file to your Google Sheet to allow multiple values in a data validation drop down list to be selected. ⭐❗👉MOST COMMON MISTAKE: When you make a copy of the sheet, go to Data Validation Advanced Options and under “If data is invalid:“ make sure “Show a warning“ is checked instead of “Reject Input“. Otherwise, nothing will happen when you try to fill the current selection from the script. 💥Hope this is helpful for you! 📊Sample Sheet with Instructions: #gid=0 ✍️In depth article: 😀 Please subscribe to my channel for more coding and spreadsheet conten
Back to Top