Conditional Dropdowns in Google Sheets скачать в хорошем качестве

Conditional Dropdowns in Google Sheets

GET THE PROJECT MANAGEMENT TEMPLATE AT http://www.jpmueller.com "How can you have a spreadsheet cell give you only choices to select based on what's been selected in another cell?" In other words, Conditional, or Dependent Dropdowns. I have heard this ask over and over again for many years and I've seen many solutions that were quite limited in terms of needing to add things like range names, or only works for one row, or doesn't consider if you change the parent, or first dropdown, etc. So I finally decided it's time to take it on in Google Sheets, and solve it in an elegant and flexible way. In this video, I'll show you an example of the final solution as well as walk you through the logic that the Appscript uses to determine whether it needs to add or remove data validation rules.