ISEMAIL

ISEMAIL is a formula that will check whether a given text string follows a valid email address format. It returns TRUE if the text is a valid email address and FALSE if it is not.

The ISEMAIL function can check the format of an email address, it does not verify whether the email address actually exists or is currently in use. It solely checks whether the text string provided matches the typical structure of an email address, including the "@" symbol, domain, and top-level domain (TLD).

##ISEMAIL(“E-MAIL”)

Other possible examples are:

##CASE(ISEMAIL("E-Mail"),1,"E-Mail",SKIPFIELD())

The formula will skip the email address format validation if the email does not return as a valid email address.

##IF(ISEMAIL("E-Mail"), "E-Mail", '')

If the email address is valid, then the result will be the email address. Otherwise, the email address field will be left blank.