Conditional Dropdown display - based on selection in a diiferent field

DanielK

Hi

Can Smartsheet do something like the following:

If Field1 is Value A, then Field2 dropdown should be x/y/z

If Field1 is Value B, then Field2 dropdown should be p/q/r

many thx

Andrée Starå

Hi @DanielK

I hope you're well and safe!

Yes.

Try something like this.

=IF(ColumnName@row = "Value A", "x/y/z", IF(ColumnName@row = "Value B", "p/q/r"))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

DanielK

it says "Unparseable"

DanielK

is this the field reference for the current row "ColumnName@row" . i also changed it to the name of the column, with no result

DanielK

many thx thus far

DanielK

do you know anyone who I could hire to build this for me?

DanielK

also - let me clarify - the dropdown would allow a selection of either :

x

y

z

\or

p

q

r

Andrée Starå

@DanielK

Happy to help!

Thanks for emailing me. I'll take a look and get back to you.