Using IF to select multiple options from a dropdown menu?


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…? 


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!