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.

Formula help to match partial email addresses to persona

Topic Labels: Formulas
Solved
Jump to Solution
2041 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Charne_Morris
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi. I’m new to airtable, and fairly new to formulas. I’m trying to build a formula that looks at the part of an email domain and based on if a specific word exists or not, enter the persona into another field.

Example
Fields are EMAIL and PERSONA
If the EMAIL domain is @usa.company.com and I’m checking if the domain contains “company” I then want to have the PERSONA be “employee”. If it does not contain “company” I want the PERSONA to be “customer”

So far this is what I have IF((FIND(“company”,{Email Domain}) >=1)“Employee”, “Customer”)

1 Solution

Accepted Solutions
Zollie
10 - Mercury
10 - Mercury

You were close:

IF( FIND("company",{Email Domain}) > 0, "Employee","Customer")

See Solution in Thread

3 Replies 3
Zollie
10 - Mercury
10 - Mercury

You were close:

IF( FIND("company",{Email Domain}) > 0, "Employee","Customer")
Charne_Morris
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you! You solved my problem. Life is good :slightly_smiling_face:

Realized I had a typo. Make sure you’re doing > not >=