0

Good afternoon,

Create a field to store an email.

The field is called "Client Contact for NewsLetter"

the valication formula has a syntax error.

Your kind help.

=AND(
ISERROR(FIND(" ", [Client Contact for NewsLetter],1)),
IF(ISERROR(FIND("@", [Client Contact for NewsLetter],2)),
    FALSE,
    AND(
        ISERROR(FIND("@",[Client Contact for NewsLetter], FIND("@", [Client Contact for NewsLetter],2)+1)),
        IF(ISERROR(FIND(".", [Client Contact for NewsLetter], FIND("@", [Client Contact for NewsLetter],2)+2)),
            FALSE,
            FIND(".", [Client Contact for NewsLetter], FIND("@", [Client Contact for NewsLetter],2)+2) < LEN([Client Contact for NewsLetter])
        )
    )
)  )

enter image description here

0

Please try this formula out, I have tried to simply it by removing the nested IF conditions and flatten it out using AND. Let me know if it helps.

=AND(
ISERROR(FIND(" ",[Client Contact for NewsLetter])),
NOT(ISERROR(FIND("@",[Client Contact for NewsLetter],2))),
ISERROR(FIND("@",[Client Contact for NewsLetter], FIND("@", [Client Contact for NewsLetter],2)+1)),
NOT(ISERROR(FIND(".",[Client Contact for NewsLetter]))),
FIND(".", [Client Contact for NewsLetter], FIND("@", [Client Contact for NewsLetter],2)+2),
FIND(".", [Client Contact for NewsLetter], FIND("@", [Client Contact for NewsLetter],2)+2) < LEN([Client Contact for NewsLetter]))
1
  • Thanks! you are great! I only add that I should have changed the "," towards ";". – Nathaniel Humberto Baldizon May 19 '20 at 5:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.