"Find()" function not finding a string within cell

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!

PS I’ve also not used the optional parameter of where to start, still have the same issue.

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} & "")
1 Like

Amazing! Makes so much more sense now. Thank you!