Skip to main content
Topics#Data ManagementDomanda di Shilo Jackson
Shilo Jackson (Regence Blue Cross) ha fatto una domanda in #Data Management
4 giu 2020, 23:49

Validation Rule for 2 separate picklist fields - they should not match.

I'm trying to create a validation rule that will prevent 2 separate picklist fields with the same pick values from matching. For example:

 

1st Month Credit (Jan, Feb, March) 2nd Month Credit (Jan, Feb, March) If January is selected in one picklist field, it cannot be selected again in the second picklist field.  
4 risposte
  1. Ahilesh Ragavan Radhakrishnan (Simplus)
    5 giu 2020, 01:37
    Hi Shilo,

     

    ++

     

    Adding not-blank checks will make sure the rule fires only when both fields are filled and not when both of them are blank.

    AND(
    NOT(ISBLANK(TEXT(1st_Month_Credit__c))),
    NOT(ISBLANK(TEXT(2nd_Month_Credit__c))),
    TEXT(1st_Month_Credit__c) = TEXT(2nd_Month_Credit__c)
    )

     

     
Scrivi una risposta...
0/9000