If Statement

Options
Catriona
Catriona
edited 03/26/24 in Formulas and Functions

Good afternoon all,

I need some assistance with a formula, if anyone can help. If there is a "Yes" selected in the Request Smarsheet Access column, I want to check the user has added a valid email address in the Email address column. The formula should return "Yes" in the Check email for Smartsheet user column, if valid email provided and "No" if not.

Any guidance would be much appreciated.

Thanks in advance



Answers

  • Samuel Mueller
    Samuel Mueller Overachievers
    edited 03/26/24
    Options

    @Catriona There is no way to check if it is "valid" but you can check if there is an @ sign

    =IF(CONTAINS["@", [Email Address]@row),"Yes", "No")

    if you are getting this data via form, depending what plan you are on you can force them to enter a valid email address.

    What they said, I misread your request ↓↓

  • heyjay
    heyjay ✭✭✭✭✭
    edited 03/26/24
    Options

    Check Email for Smarsheet User =

    =IF(AND(
    [Request Smarsheet Access]@row = "Yes", 
    FIND("@", [Email Address]@row) > 0), 
    "Yes", "No")
    

    Im using FIND to look for @ in the email address column to check for valid email. That may not work 100% of the time. But i hopw that this is a good start for you.

    ...

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!