OR(
Authorized_Signer__c = DS_First_CC_Recipient__c,
Authorized_Signer__c = DS_Second_CC_Recipient__c,
DS_First_CC_Recipient__c = DS_Second_CC_Recipient__c
)
How can I modify these fields so it will not fire when the fields contain no values?
Example, if Authorized_Signer__c and DS_First_CC_Recipient__c contain no value , I don't want VR to fire.
6 answers
As a full and final formula, you can copy paste this:
OR(
AND(
NOT(ISBLANK(Authorized_Signer__c)),
NOT(ISBLANK(DS_First_CC_Recipient__c)),
Authorized_Signer__c = DS_First_CC_Recipient__c
),
AND(
NOT(ISBLANK(Authorized_Signer__c)),
NOT(ISBLANK(DS_Second_CC_Recipient__c)),
Authorized_Signer__c = DS_Second_CC_Recipient__c
),
AND(
NOT(ISBLANK(DS_First_CC_Recipient__c )),
NOT(ISBLANK(DS_Second_CC_Recipient__c)),
DS_First_CC_Recipient__c = DS_Second_CC_Recipient__c
)
)
