Skip to main content
Topics#Data ManagementJulie Prasch's Question
Julie Prasch asked in #Data Management
Jul 26, 2016, 6:15 PM

Validation rule - based on a certain picklist value 2 other picklist fields must be the same value

I think this will need to be "If / Then" - 

 

If picklist X1_Product_Requested__c is SMARTci or SMARTci+

 

Then the picklist value for X1_GirtClip_Depth__c and X1_Insulation_Depth__c have to be the same
4 answers
  1. Sunil Sarilla (M&G Investments)
    Jul 26, 2016, 6:26 PM
    Hi Julie,

     

    Please try the below

    AND(
    CASE(X1_Product_Requested__c,
    "SMARTci",1,
    "SMARTci+",1,
    0)=1,
    TEXT( X1_GirtClip_Depth__c) <> TEXT( X1_Insulation_Depth__c)
    )

     

     
Write an answer...
0/9000