You need to sign in to do that
Don't have an account?

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 ))
)
or(
and(!isblank( Strategic_Partner__c ),!ISBLANK( Reseller__c )),
or(!ISBLANK( Reseller__c) ,!isblank( Strategic_Partner__c ))
)
Try this
AND( Strategic_Partner__c <> Null , Reseller__c <> Null)
Thanks
Jega
Sweet potatotec
All Answers
If you ONLY want it to error when both are filled in:
If you want it to error when 1 or both are filled in:
Try this
AND( Strategic_Partner__c <> Null , Reseller__c <> Null)
Thanks
Jega
Sweet potatotec
It's not work for me.
It stores the value if two fields are filled.
Thanks
Jega
Hi @dave Those should have worked but did not. @Jega that worked and was very clean. Thank you. @Raj I had the result that Raj did.
Thanks, everyone.