1
AND(
    INCLUDES(Site_Location__r.Tracks__c ,TEXT(Track_Assignment__c))
)

Site_Location__r.Tracks__c is Multipicklist, and Track_Assignment__c is picklist field.

I am trying to write a validation rule to check if the Track_Assignment__c value is contained in the Site_Location__r.Tracks__c Multipicklist".

Error: Incorrect parameter type for function 'INCLUDES()'. Expected Text Literal, received Text

1 Answer 1

2

Note from the documentation on INCLUDES that the syntax is:

INCLUDES(multiselect_picklist_field, text_literal)

A text literal is a single explicit value such as "My Picklist Value". You can't compare another field here, because text is a different type that is not accepted in this case. You will need to write an Apex Trigger to perform this validation.

1
  • 1
    Thanks for the clarification. I have already written the trigger, however just wanted to check if we can avoid the trigger.
    – Ajay
    Nov 13, 2016 at 21:06

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .