I am requesting for a Validation Rule below.
I have 3 fields in a cutom object below
Type__c (picklist)
Court__c (lookup)
Court_Division__c (lookup)
VR - If Type__c field = "Bankruptcy" then Court__c and Court_Division__c need to contain a value.
I created the VR below but it is not working correctly.
AND(
ISPICKVAL(Type__c,"Bankruptcy"),
ISBLANK(Court__c),
AND(
ISBLANK(Court_Division__c)
))
Regards,
2 réponses
Hi Forrest, This should work for you
AND(
ISPICKVAL(Type__c,"Bankruptcy"),
OR(
ISBLANK(Court__c),
ISBLANK(Court_Division__c)
)
)