• Sarah Wiens
  • NEWBIE
  • 10 Points
  • Member since 2020

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
I'm setting up a custom "Graduating Class" field for our contacts. I want users to either leave the field blank or enter numbers in the field in the YYYY format (no commas). How do you recommend I write the validation rule?

So far I have NOT(ISNUMBER( Graduating_Class__c )) to strip the comma, but I'm not sure how to modify to allow for a blank option.
I'm setting up a custom "Graduating Class" field for our contacts. I want users to either leave the field blank or enter numbers in the field in the YYYY format (no commas). How do you recommend I write the validation rule?

So far I have NOT(ISNUMBER( Graduating_Class__c )) to strip the comma, but I'm not sure how to modify to allow for a blank option.