You need to sign in to do that
Don't have an account?
Joanna Kirk
How do I add 'can be blank' to my validation rule formula?
Hi everyone!
My validation rule, below, works, but I need to make it possible for this field to be left blank:
IF(Value(fieldname) > Year(TODAY()),true,IF(LEN(fieldname)=4,false,true))
- I think I need to add something but not sure where to start
IF (not(isblank(fieldname)),
????????????,
NULL)
I have not yet go my head around the syntax!
My validation rule, below, works, but I need to make it possible for this field to be left blank:
IF(Value(fieldname) > Year(TODAY()),true,IF(LEN(fieldname)=4,false,true))
- I think I need to add something but not sure where to start
IF (not(isblank(fieldname)),
????????????,
NULL)
I have not yet go my head around the syntax!
Thanks
All Answers
Thanks
- So many parenthesises!