PUTTING AN "OR" INTO THE FORMULA FIELD COLUMN FILTER
I've created a formula field that concatenates choices from a multiple choice field. So if a user chooses Apples and Pears, it shows as "Apples,Pears".
In a table I want to apply a filter to this formula field so that it shows only "Apples" (single choice) or "Pears" (single choice) or "[nothing]" but not "Jackfruit" (single choice) or "Bananas" (single choice).
Can this be done? I'm not a fruiterian, it's just an example.
6 replies
-
Try this:
like "Apples" or like "Pears" or like "[nothing]"
-
I tried
like "Apples" or like "Pears" or like ""
and it didn't exclude the other values. "" means null value, right?
-
and if you try with this:
ike "Apples" or like "Pears" or like null
-
That doesn't work either. Like "Apples" works on its own (returns any line item with Apples in it). What it doesn't seem to interpret is the or like. Add that and everything is returned.
-
Hi,
What about
like "Apples" or like "Pears" or = nullBest, Jörg
-
That doesn't capture the blank items, but this works:
like "Apples" or like "Pears" or = ""
Problem solved. Thanks!
Content aside
- 5 yrs agoLast active
- 6Replies
- 1132Views