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

[aaron_altamura]

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!

[aaron_altamura]

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

[Justin_Barrett]

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

[aaron_altamura]

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