22 Aralık 2014 Pazartesi

Sharepoint Column E-mail Validation Formula

Sharepoint List Column E-Mail Validation Fromula

=AND(    ISERROR(FIND(" ", [Email],1)), 
IF(ISERROR(FIND("@", [Email],2)), 
FALSE, AND(ISERROR(FIND("@",[Email], FIND("@", [Email],2)+1)),
IF(ISERROR(FIND(".", [Email], FIND("@", [Email],2)+2)),FALSE,FIND(".", [Email], FIND("@", [Email],2)+2) < LEN([Email])))))


Reference