intoxicated_curveball
asked on
Modify column validation SharePoint
This line works to validate email address
But now I only want it to use above if email field is NOT empty.
Can you help?
=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])))))
But now I only want it to use above if email field is NOT empty.
Can you help?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.