I have two pick list fields product__c and Assigned_group__c

I am trying to write a validation if value on product__c picklist is DR user can only select L2 value on Assigned_group__c picklist and shows error if try to select other values on Action_Owner__c.

I have written this rule:

AND( ISPICKVAL(Case__r.Product_Type__c, "Digital Risk"), ISPICKVAL( Action_Owner__c, "L2" ))

but its not firing.

  • Well, your rule as written doesn't match your description. Is it Assigned_group__c or Action_Owner__c?
    – David Reed
    Sep 17, 2018 at 20:31
  • its Action_Owner__c edited in description as well
    – teeshu
    Sep 17, 2018 at 20:34

1 Answer 1


I added NOT condition and it worked.

AND( ISPICKVAL(Case__r.Product_Type__c, "Digital Risk"), NOT(ISPICKVAL( Action_Owner__c, "L2" )))

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .