Skip to main content
I'm looking for some help with a validation rule I'm hoping the community can help with.

 

My needs are as follows:

 

If value "A" of picklist 1 is chosen, one of the two scenarios below must be satisfied:

 

- Value "Y" of a second picklist must be chosen

 

OR

 

- ANY value in a third picklist must be chosen

 

Hope that makes sense. 
2 respostas
  1. 31 de out. de 2017, 14:12

    Like this:

    AND(

      TEXT(Picklist1__c) = 'A',

      TEXT(Picklist2__c) <> 'Y',

      ISBLANK(TEXT(Picklist3__c))

    )

    That's it.

0/9000