Conditional dynamic dropdown contact from another sheet
Is this possible?
Is there a way to get conditional dropdowns?
column 1 column 2 dropdown contact
trade cat Market
Framer Pittsburgh dropdown would pull framer from Pittsburgh
All the contacts would on 1 Master sheet. Master sheet would have corresponding Trad cat column and Market column.
On the construction schedule the Trade cat column would be already filled out as well as the market column.
So each row would have a task on the construction schedule
Also new construction schedules would be created from a templated schedule.
See above example. So line 4 would see excavation phase and market of Pittsburgh and return only return sub contractor that has excavator and Pittsburgh in the sub sheet columns.
Help Article Resources
Check out the Formula Handbook template!