If contains, then "Yes"

[Dani_Oliver]

Hey there, trying to get an IF/THEN statement correct here.

It’s a donation database. Each donation is linked to a Donor Account and a Campaign. In my Donor Accounts tab, I’m using a lookup field to determine which Campaigns each donor has donated through. In another column, I’d like it to populate “Yes” if the donor has already given/is tagged to a particular campaign, “No” if they haven’t.

Thoughts?

[Eric_Goldman1]

Hey @Dani_Oliver,

You can easily use the Switch()formula to do this!

Here is a full explanation of how the switch formula works.

Best,
Eric

[Dani_Oliver]

I’m not sure this would work if there are multiple records listed in Campaigns, though, right? I need “if it contains”, not “if it is.”

[Eric_Goldman1 · Accepted solution]

Got it! I see two options here:

1. You could use FIND() to determine if the text you are looking for is in the cell and then an IF() to populate “YES” or “NO”. This thread has a good example.

2. You could use REGEX with this App: https://miniextensions.com/airtable-regular-expression/

Let me know if this takes care of it!