Link to home
Start Free TrialLog in
Avatar of intoxicated_curveball
intoxicated_curveball

asked on

Modify column validation SharePoint

This line works to validate email address
=AND(ISERROR(FIND(" ",[Email Address],1)),IF(ISERROR(FIND("@",[Email Address],2)),FALSE,AND(ISERROR(FIND("@",[Email Address],FIND("@",[Email Address],2)+1)),IF(ISERROR(FIND(".",[Email Address],FIND("@",[Email Address],2)+2)),FALSE,FIND(".",[Email Address],FIND("@",[Email Address],2)+2)<LEN([Email Address])))))

Open in new window


But now I only want it to use above if email field is NOT empty.

Can you help?
ASKER CERTIFIED SOLUTION
Avatar of Bembi
Bembi
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial