Conditional dynamic dropdown contact from another sheet

Jon Barto
Jon Barto โœญโœญโœญโœญโœญ
edited 10/24/23 in Formulas and Functions

Hello All

Is this possible?

Is there a way to get conditional dropdowns?

Meaning

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.


Screenshot 2023-10-12 203015.png

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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!