Use Google Apps Script To Add Dependent Drop Down Options
Adding Dependent/Dynamic Drop Downs to your spreadsheet can give it a HUGE boost in data quality and make it much easier to … source
Read Full News