Skip to main content
Topics#Data ManagementAlastair Batchelor's Question
Alastair Batchelor (Thomsons Online Benefits) asked in #Data Management
Oct 9, 2013, 11:34 AM

Validation to see if the values in two picklist fields are the same?

I need to write a validation.

 

If the values between 2 fields on the same object are the same then it should not save. The fields are picklist. For example.

 

IF(ISPICKVAL(field1_c) =(field2_c))

 

But this get the follwoing error:

 

Error: Field Pain_Point_1__c is a picklist field. Picklist fields are only supported in certain functions
14 answers
  1. Subramanyam Meare (ADP)
    Oct 9, 2013, 1:14 PM
    Give this a shot:-

     

    AND(

     

    NOT(ISBLANK(text( field1_c ))),

     

    NOT(ISBLANK(textfield2_c ))),

     

    TEXT(field1_c)=TEXT(field2_c))

     

    Regards,

     

    Subbu.
Write an answer...
0/9000