Hi all - I'm trying to write a simple formula that returns a Yes or a No if the Role Rollup (from People) field contains CROPPS Member anywhere in the list. As you can see, it's only returning Yes if the field equals CROPPS Member, not contains CROPPS Member. I've tried several iterations of this formula (search, switch, trim) none returning correct results.
Any ideas?
Thanks!
Kelsey
The FIND function returns a number greater than 1 if the text is found and 0 if the text is not found.
So I think if you alter this formula so that your FIND function returns true or false it will work nested in the IF function.
Something like:
IF
IF(
FIND("CROPPS Member", {Role Rollup (from People)}) > 0,
"Yes",
"No"
)New to Airtable, but I think that will fix the issue.
Hm, not sure how your data's set up, but try converting the rollup to a string to see if that helps:
IF(
FIND(
"CROPPS Member",
{Tags Rollup (from People)} & ""
),
"Yes",
"No"
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.