Sign Up ›
  • Bneighbors
  • NEWBIE
  • 10 Points
  • Member since 2018
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
SOLVED
7 replies

How to create a Validation rule of both fields can be blank but both can not be filed in.

I'm trying to set up a Validation rule to show an error if both of the below fields are filled in but not if both are blank. 

or( 
and(!isblank( Strategic_Partner__c ),!ISBLANK( Reseller__c )), 
or(!ISBLANK( Reseller__c) ,!isblank( Strategic_Partner__c )) 
)
SOLVED
7 replies

How to create a Validation rule of both fields can be blank but both can not be filed in.

I'm trying to set up a Validation rule to show an error if both of the below fields are filled in but not if both are blank. 

or( 
and(!isblank( Strategic_Partner__c ),!ISBLANK( Reseller__c )), 
or(!ISBLANK( Reseller__c) ,!isblank( Strategic_Partner__c )) 
)