Help

If contains, then "Yes"

Topic Labels: Formulas
Solved
Jump to Solution
16219 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!