Skip to main content
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개
  1. 2020년 6월 5일 오전 1: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)

    )

     

     
0/9000