function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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!