You need to sign in to do that
Don't have an account?
RDSS
Validation rule should not fire if fields are empty
Hi,
I am comparing two fields but validation rule fires even if the fields are empty. I want to skip the condition when fields are empty. It should only compare when fields have values.
AND(
NOT(ISBLANK(Account__r.NomineeAddress1__c)),
(IF( Spouse_Name__c = Account__r.NomineeAddress1__c , True, false)))
Thanks
Raman
I am comparing two fields but validation rule fires even if the fields are empty. I want to skip the condition when fields are empty. It should only compare when fields have values.
AND(
NOT(ISBLANK(Account__r.NomineeAddress1__c)),
(IF( Spouse_Name__c = Account__r.NomineeAddress1__c , True, false)))
Thanks
Raman
try with nested IF statement like
IF((ISBLANK(Account__r.NomineeAddress1__c)),false,IF(Spouse_Name__c = Account__r.NomineeAddress1__c,true, false))
Regards,
GM