Use Google Apps Script To Add Dependent Drop Down Options
TL;DR — Adding Dependent/Dynamic Drop Downs to your spreadsheet can give it a HUGE boost in data quality and make it much easier to manage. In this video, we'll write a script to update the drop down optio…
Adding Dependent/Dynamic Drop Downs to your spreadsheet can give it a HUGE boost in data quality and make it much easier to manage. In this video, we'll write a script to update the drop down options within your Google Sheet. We'll be making use of the onEdit triggered event to make this happen.
