Skip to main content
Solved

Formula help to match partial email addresses to persona

  • February 21, 2020
  • 3 replies
  • 29 views
C

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

Best answer by Zollie

You were close:

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

3 replies

Z
Forum|alt.badge.img+18
  • Zollie
  • Inspiring
  • Answer
  • February 21, 2020

You were close:

IF( FIND("company",{Email Domain}) > 0, "Employee","Customer")
C
  • Charne_Morris
  • Author
  • New Participant
  • February 21, 2020

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

Z
Z
Forum|alt.badge.img+18
  • Zollie
  • Inspiring
  • February 21, 2020

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


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

Terms & ConditionsAccessibility statement