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…?
Help Article Resources
Check out the Formula Handbook template!