Multiple Selection Data Validation in Google Sheets

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.

⭐ Get the FREE Sheet and code - https://www.gotsheet.xyz/c/multiple-s...

Review of a couple updates to the UI since original publication:    • Multiple Selection Data Validation Up...  

⭐❗👉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.

We receive commission on purchases made through some links on this page
_______________________________________________

🎓Software Recommendations:

► Starting a Newsletter? Check out Beehiiv with a free trial and 20% off your first 3 months: https://www.beehiiv.com/?via=eamonn
► ConvertKit - creator marketing & newsletter platform - https://partners.convertkit.com/358pj...
► HubSpot free CRM software for sales, marketing, customer service, operations teams. https://hubspot.sjv.io/c/4186908/1001...
► Notion - productivity & note-taking app - https://affiliate.notion.so/p7771a8zwlsu
► Carrd - one page landing sites - https://try.carrd.co/s4x1c97b
► Coefficient - import data and sync with your business systems in Google Sheets - https://coefficient.io/?via=984f9f

_______________________________________________
🎓Data Course Suggestions: (coursera)

► Advanced Data Analytics Certificate by Google: https://imp.i384100.net/21dWGa
► Microsoft Power BI Data Analyst Certificate - https://imp.i384100.net/4PgjK3
►Microsoft Business Analyst Certificate - https://imp.i384100.net/anamAq
► Cybersecurity by Google: https://imp.i384100.net/VmN6oM
► Google Cloud Data Analytics Certificate - https://imp.i384100.net/B0ZJb0

_______________________________________________
🎓AI Course Suggestions: (coursera)

► IBM AI Developer Certificate - https://imp.i384100.net/B0ZR9L
► Overview IBM AI Engineer Certificate - https://imp.i384100.net/KjnyA9
► Google AI Essentials - https://www.coursera.org/learn/google...

_______________________________________________

🖥️ Office items I can't live without:
https://amzn.to/3uqSO7Q (amazon)

📲 Find me
on LinkedIn:   / eamonncottrell  
on Twitter:   / eamonncottrell  
_______________________________________________