Sign Up ›
  • Joanna Kirk
  • NEWBIE
  • 20 Points
  • Member since 2015
  • CLOUT!
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 5
    Replies
SOLVED
2 replies

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! 
SOLVED
9 replies

How do I create a field for 'year' (with a validation rule that it cannot be in the future)?

e.g. trading since (year)

I've been told to start with a number field (4 digit limit) but need a hint on where to start with the sytax! Any help appreciated.
SOLVED
2 replies

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! 
SOLVED
9 replies

How do I create a field for 'year' (with a validation rule that it cannot be in the future)?

e.g. trading since (year)

I've been told to start with a number field (4 digit limit) but need a hint on where to start with the sytax! Any help appreciated.