Skip to main content
All,

 

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
  1. 9 avr. 2015, 22:36
    Hi Forrest, 

     

    This should work for you

    AND(

    ISPICKVAL(Type__c,"Bankruptcy"),

    OR(

      ISBLANK(Court__c),

    ISBLANK(Court_Division__c)

    )

    )