I have a requirement -
Create a multiselect picklist field on account Named - Area and add to the page layout
There is a field on opportunity called pricebook and it is a lookup to Pricebook object.
NOT CONTAINS(TEXT (Area__c),Opportunity.Pricebook__r.Name)
Then Create a validation rule -
Pricebook custom field
TEXT (Area__c) <> Opportunity.Pricebook__r.Name
Error message: "You must select a pricebook that matches the Pricebook field on the related Account record."
I tried and it gives me an error - Error: Incorrect parameter type for function 'INCLUDES()'. Expected Text Literal, received Text.
I go through with the this document, is there a way i can create a validation rule?
The client doesn't want to use a trigger.
Is there a way to compare values of multi-select picklist with another text field?
Please suggest !!