Hi, I can’t find a solution to this:
I have a Lookup field that consists of multiple text values separated by a comma. I’m adding a seperate column to indicate the status based of that Lookup field which should contain of 3 possible values:
Now it seems that AND doesn’t work in combination with FIND.
Has anyone found a solution for this?