You need to sign in to do that
Don't have an account?
Lorenzo Williamson
Validation query
Hi Guys,
Forgive me if I'm missing the blatantly obvious here, I'm still relatively new. I would like to have the validation rule below apply only when the field is not blank, I've been having trouble constructing the right syntax to achieve this.
NOT(BEGINS(Phone,"00")) || NOT(ISNUMBER(Phone)) || CONTAINS(Phone,".")
Any help is much appreciated
Thanks
Is this what you are looking for!
All Answers
What is the name of the field for which you want to check for not blank. Is it Phone?
If so, use NOT(ISBLANK(Phone)) in validation rule definition.
AND(NOT(ISBLANK(Phone)),(NOT(BEGINS(Phone,"00")) || NOT(ISNUMBER(Phone)) || CONTAINS(Phone,".")))
Is this what you are looking for!