Using IF to select multiple options from a dropdown menu?

Emma Picardi

Hello! I’m wondering if it’s possible to use a formula to select multiple options in a dropdown menu cell. I have the “Allow multiple values per cell” toggle switched to on, but when I use multiple IF statements to select multiple options, I only see the first statement’s “value_if_true”

Am I missing something, or is this just not an offered functionality? Or is there another way to go about it, e.g. using an AND statement for the “value_if_true” to display more than one of my dropdown options…? 

Thanks!!

Andrée Starå

Hi @Emma Picardi

I hope you're well and safe!

Try something like this. (You'd use CHAR(10) to add multiple options together)

=IF(ResultCheck@row = "Yes", 1 + CHAR(10) + 2 + CHAR(10))

https://help.smartsheet.com/function/char

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Emma Picardi

I hope you're well and safe!

Try something like this. (You'd use CHAR(10) to add multiple options together)

=IF(ResultCheck@row = "Yes", 1 + CHAR(10) + 2 + CHAR(10))

https://help.smartsheet.com/function/char

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Emma Picardi

Thanks Andrée! That did the trick as soon as I changed my column to Text/Number rather than Dropdown

Andrée Starå

@Emma Picardi

Excellent!

You're more than welcome!