Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

If contains, then "Yes"

Topic Labels: Formulas
Solved
Jump to Solution
16743 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Dani_Oliver
6 - Interface Innovator
6 - Interface Innovator

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?

1 Solution

Accepted Solutions

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!

See Solution in Thread

3 Replies 3
Eric_Goldman1
7 - App Architect
7 - App Architect

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

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.”

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!