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