Is there anyway to write an if statement to be true. If you are using a multi-select drop down with more than one choice. if({multi-select} = “Choice 1” & “Choice 2” , “Yes”). I know this is incorrect but how would a write it for the combined two choices that have to be made via a multi-select dropdown to be true. I hope that makes sense.
Is this what you’re looking for?
There’s probably a more elegant solution, but this is what I came up with.
Because we can’t read the dropdown’s values as an array (afaik), I just used SEARCH()
SEARCH() returns the index of where the target tags were found and returns nothing otherwise, so we’re just looking for when SEARCH() returns a value > 0.
IF(
AND(
SEARCH(“tag1”, {Dropdown}, 1) > 0,
SEARCH(“tag2”, {Dropdown}, 1) > 0),
“true”,
“false”)
Thank you so much.