Conditional Drop-down list columns

Jana@al-a
Jana@al-a
edited 12/09/19 in Formulas and Functions

Hey

Is it possible to have the the drop-down list of a column changed based on the value of another column?

Eg. If column A's value is set to "Work stage 2" column B's drop-down list will have a specific list, but when it is set to "Work stage 2" column B's drop-down list changes automatically to a different list.

 

Say Column A has a drop-down list of:

Work stage 1

Work stage 2

Work stage 3

Work stage 4 

Column B has a drop-down list based on the value selected in Column A.

 

Regards,

Jana Brits

 

 

«1

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!