Column Validation Single Line Text with blank or multiple email addresses separated by semicolon
I have a SharePoint Online list with a single line text column named Cc… Email (i didn’t create that one) that I have been trying to formulate the validation to only allow valid email addresses. The address field can be empty, single entry or multiple entries separated by a semicolon. I’ve tried everything including chatgpt and copilot to find a formula that will work correctly. Nothing seems to work and it seems like this should be fairly simple. What am I missing?
=OR(
ISBLANK([Cc… Email]),
AND(
NOT(ISERROR(FIND(” “, [Cc… Email]))),
ISERROR(FIND(“;;”, [Cc… Email])),
ISERROR(FIND(“;”, [Cc… Email], LEN([Cc… Email])-1)),
ISERROR(FIND(“@”, [Cc… Email])),
ISERROR(FIND(“@”, [Cc… Email], FIND(“@”, [Cc… Email])+1)),
ISERROR(FIND(“.”, MID([Cc… Email], FIND(“@”, [Cc… Email])+1, LEN([Cc… Email])))) = FALSE,
ISERROR(FIND(” “, MID([Cc… Email], FIND(“@”, [Cc… Email])+1, LEN([Cc… Email]))))
)
)
I have a SharePoint Online list with a single line text column named Cc… Email (i didn’t create that one) that I have been trying to formulate the validation to only allow valid email addresses. The address field can be empty, single entry or multiple entries separated by a semicolon. I’ve tried everything including chatgpt and copilot to find a formula that will work correctly. Nothing seems to work and it seems like this should be fairly simple. What am I missing?=OR(ISBLANK([Cc… Email]),AND(NOT(ISERROR(FIND(” “, [Cc… Email]))),ISERROR(FIND(“;;”, [Cc… Email])),ISERROR(FIND(“;”, [Cc… Email], LEN([Cc… Email])-1)),ISERROR(FIND(“@”, [Cc… Email])),ISERROR(FIND(“@”, [Cc… Email], FIND(“@”, [Cc… Email])+1)),ISERROR(FIND(“.”, MID([Cc… Email], FIND(“@”, [Cc… Email])+1, LEN([Cc… Email])))) = FALSE,ISERROR(FIND(” “, MID([Cc… Email], FIND(“@”, [Cc… Email])+1, LEN([Cc… Email])))))) Read More