I would like to make a formula that does this:
Display 1 if the item “lightyellow” was selected from the Color multiselect
I see that I can use the SEARCH or FILTER functions. However, these will also evaluate to true if a non-exact-matching option was selected.
For example, let’s say I have the options “yellow” and “lightyellow”. The following formula will undesirably match items that have “lightyellow” selected.
Is there nothing like this?