If Statement

Catriona

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

Samuel Mueller

@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

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.