You need to sign in to do that
Don't have an account?
Abid ullah
Error: Syntax error. Extra AND
NOT(
OR(
Country = 'US',
Country = 'USA',
Country = 'United State of America',
ISBLANK(Country)
)
)
AND(
LEN(State)= 2,
CONTAINS(State, "AB"},
CONTAINS(State, "CD"},
CONTAINS(State, "EF"}
)
OR(
Country = 'US',
Country = 'USA',
Country = 'United State of America',
ISBLANK(Country)
)
)
AND(
LEN(State)= 2,
CONTAINS(State, "AB"},
CONTAINS(State, "CD"},
CONTAINS(State, "EF"}
)
Please try the below validation rule:
Thanks,
Maharajan.C
All Answers
Can you please explain the scenrio...
Why you are writing this formula...
Thanks,
Maharajan.C
I am writing a validation rule for lead object that lead state will be only two character and character should be predefined and the country of lead will be US or USA or United state of America or blank.
Please try the below validation rule:
Thanks,
Maharajan.C
This is working for me!