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:
- IF FIND “Paid” = Completed
- IF FIND “Pending” = Pending
- IF FIND AND “Pending” & “Completed” = Partially Completed
Now it seems that AND doesn’t work in combination with FIND.
Has anyone found a solution for this?