Hello,
So I’m attempting to find the string “Active” as so:
Yet it’s not picking up the string for a number of records (ex. should be 1 for the first record):
Why is this happening? Thanks!
"Find()" function not finding a string within cell
+12
+21This is happening because of the format of the data in the field you’re searching. You’re using a lookup field, which returns an array. The FIND() function is looking for a string, and (sadly) doesn’t automatically convert an array into a string. You need to force the conversion by concatenating the target field with an empty string, like this:
FIND("Active", {status-contracts} & "")This is happening because of the format of the data in the field you’re searching. You’re using a lookup field, which returns an array. The FIND() function is looking for a string, and (sadly) doesn’t automatically convert an array into a string. You need to force the conversion by concatenating the target field with an empty string, like this:
FIND("Active", {status-contracts} & "")Amazing! Makes so much more sense now. Thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.