Listen "Validate Your Data - Multiple Selections with Apps Script"
Episode Synopsis
Hi there! Thanks for listening, I Want to Hack is a weekly discussion of coding and spreadsheet concepts. I hope you'll subscribe to follow along! Links at the bottom, but if you do nothing else, would you consider subscribing to my YouTube channel where I share spreadsheet and coding tutorials? 😉 I'm hoping to grow this to 1000 subscribers this year!Episode Overview:We walk through how to create an Apps Script code to have multiple selection capabilities in the data validation drop down menus in Google Sheets. This isn't available out of the box, but I came across a great solution originally coded by Alexander Ivanov and applied it to my own sheets.The links to my video walkthrough and the Google Sheet we're using are available below.Please subscribe to this podcast if you haven't already! I really appreciate it, and look forward to talking with you on the next pod!Resources mentioned:Video Walkthrough for Multiple Selection Data ValidationExample Google Sheet with the CodeIn depth articleFind me on my siteWatch me on YouTube @eamonncottrell Follow me on Linkedin @EamonnCottrellBuy me a coffee on BuyMeACoffeeLaugh at me on gitHub @sieis
More episodes of the podcast I Want To Hack
Easy Web Scraping With Google Sheets
14/08/2023
Custom Named Functions in Google Sheets
20/03/2023
Nested Functions
23/02/2023
Grainy CSS Backgrounds
16/02/2023
Dynamic Listing with Query in Google Sheets
03/02/2023
Clean Your Own Data
20/01/2023
Dollar Dollar Bill Show Me The Money, Excel
12/01/2023
Less Code More Content
09/01/2023
ZARZA We are Zarza, the prestigious firm behind major projects in information technology.