+ Start a Discussion
Joanna KirkJoanna 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! 
Best Answer chosen by Joanna Kirk
Jithin Krishnan 2Jithin Krishnan 2
Please try this:
IF(isBlank(fieldname),false,IF(Value(fieldname) > Year(TODAY()),true,IF(LEN(fieldname)=4,false,true)))

Thanks

All Answers

Jithin Krishnan 2Jithin Krishnan 2
Please try this:
IF(isBlank(fieldname),false,IF(Value(fieldname) > Year(TODAY()),true,IF(LEN(fieldname)=4,false,true)))

Thanks
This was selected as the best answer
Joanna KirkJoanna Kirk
Great. Thank you Jithin. it's working.
- So many parenthesises!