I'm looking to make the Inactivation_Date__c required if Active__c (picklist) is "Inactive" and make the Date field not able to be used if Active__c is "Active". I tried entering a validation rule of:
AND(ISPICKVAL(Active__c,"Inactive"),
ISBLANK(Inactivation_Date__c))
But I am still able to enter a date in inactivation field even if still Active. Any idea what I am doing wrong?
Thanks!
10 个回答
You could use a Formula like this
CASE(Active__c,
"Active","0",
"Inactive","1",
NULL )
<>
IF(ISBLANK(Inactivation_Date__c), "0", "1" )
