+5Hi, 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?
+31Hey Joel, think we’re getting hit by the way lookups are formatted
Check this base out
FIND works as expected for linked fields and rollup fields but not for lookups it seems
+5Hey Joel, think we’re getting hit by the way lookups are formatted
Check this base out
FIND works as expected for linked fields and rollup fields but not for lookups it seems
The rollup field worked for me! Thank’s for your support :pray: :blush:
+35@Adam_TheTimeSavingCo @Joel1
FIND works with lookup fields, but you need to turn the lookup field into a string by adding & "" after the field name like this:
{Lookup Field} & ""
So, to find something in a Lookup field, it would look like this:
FIND("phrase to look for", {Lookup Field} & "")
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.