Dropdown Menu Functionality

Options

Is there a way to control what appears in a dropdown menu based on what is selected in a different cell.

i.e.

Dropdown Columns:

[A] & [B] as [B] is dependent of [ A]

If “School” is selected in cell A, then in cell B your choices will be Z, Y, Z

However, if you select “Work” in call A, your cell B choices will be S, T, U, V

This is for use with a form.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!