Skip to main content
Topics#Data ManagementQuestion de Mike Callaghan
Mike Callaghan (SunTrust) a posé une question dans #Data Management
5 févr. 2016, 17:02

Four Picklists Containing the Same Value, Validation Rule

I have four picklists, Picklist 1, 2, 3 and 4 all contain the exact same values.

 

If any of them contain Reason 1 or Reason 2, I don't want the validation rule to fire.

 

AND( 

 

TEXT( Picklist ) = 'Value',

 

OR(

 

NOT(CONTAINS(TEXT( Picklist_1__c ), 'Reason 1')), 

 

NOT(CONTAINS(TEXT( Picklist_1__c ), 'Reason 2')),

 

NOT(CONTAINS(TEXT( Picklist_2__c ), 'Reason 1')), 

 

NOT(CONTAINS(TEXT( Picklist_2__c ), 'Reason 2')),

 

NOT(CONTAINS(TEXT( Picklist_3__c ), 'Reason 1')), 

 

NOT(CONTAINS(TEXT( Picklist_3__c ), 'Reason 2')),

 

NOT(CONTAINS(TEXT( Picklist_4__c ), 'Reason 1')), 

 

NOT(CONTAINS(TEXT( Picklist_4__c ), 'Reason 2')))))

 

Tried this a couple different of ways and still can't get the logic correct.
2 réponses
  1. Mayank Srivastava (eVerge Group)
    5 févr. 2016, 17:09
    AND(
        TEXT(Picklist)       = 'Value',
        TEXT(Picklist_1__c) <> 'Reason 1', 
        TEXT(Picklist_1__c) <> 'Reason 2',
        TEXT(Picklist_2__c) <> 'Reason 1', 
        TEXT(Picklist_2__c) <> 'Reason 2',
        TEXT(Picklist_3__c) <> 'Reason 1', 
        TEXT(Picklist_3__c) <> 'Reason 2',
        TEXT(Picklist_4__c) <> 'Reason 1', 
        TEXT(Picklist_4__c) <> 'Reason 2'
    )

     

    You don't need to use the CONTAINS function.
Rédiger une réponse...
0/9000