SWITCH() formula be used to output different criteria for different options and/or combinations of a multiple select field?
Essentially, I want to say: “If
multiple select field contains
Option 1, return
Result A. If it also contains
Option 2, return
Result A, Result B.”
So far, when I’ve made a
SWITCH() function, it will only return if a multiple select field is one thing or another but won’t return if it’s both things.
How could this be built without a zillion characters of different scenarios written out in the formula?