• Neeraj Mendhe
  • 0 Points
  • Member since 2021

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
  • 1



I am using a validation rule to check that a picklist selection does not match an sObject field (which also is a picklist field).


Here is the formula I am using:


(ISPICKVAL(Language__c,'English')   &&  $ObjectType.SetUp__c.Fields.Msgs_Lang__c = 'English')


The error message is not triggered so I checked and the problem is with the object  $ObjectType.SetUp__c.Fields.Msgs_Lang__c which is not returning its true value (the problem might be it is a picklist field).

I tried with VLOOKUP instead, however it does not support  picklist fields.


Any suggestions as to how could I compare a picklist selection to an other custom field on other sObject?


Thanks a lot!

  • July 19, 2013
  • Like
  • 0