You need to sign in to do that
Don't have an account?
sni
INCLUDES won't match
Hi,
I have a custom multi-select picklist which contains some languages like "German" "English" and "French" on Contact.
Now, I need to pass the selected languages to my formula for a button/link URL on Opportunities.
This is my test code:
I tested mutliple combinations in the picklist.
Btw if I just let it print out "Contact.Language__c", it works fine.
What am I missing?
Thanks
I have a custom multi-select picklist which contains some languages like "German" "English" and "French" on Contact.
Now, I need to pass the selected languages to my formula for a button/link URL on Opportunities.
This is my test code:
{!IF(INCLUDES(Contact.Language__c, "German"), "10202", "") &IF(INCLUDES(Contact.Language__c, "English"), "10201", "") &IF(ISBLANK(Contact.Language__c), "10204", "")}But the INCLUDES always return false and in this case the empty string.
I tested mutliple combinations in the picklist.
Btw if I just let it print out "Contact.Language__c", it works fine.
What am I missing?
Thanks
Greetings!
You need to use ISPICKVAL() istead of INCLUDES() since it is picklist field and you are checking for the value.
I would suggest you to try it with the same to fix the issue.
Please mark it as best answer if it helps you to fix the issue.
Thank you!
Regards,
Shirisha Pathuri
thanks for your answer, but as stated in the first sentence, this is a multi-select picklist which only supports certain functions (as of the error message and this doc: https://help.salesforce.com/articleView?id=tips_for_using_picklist_formula_fields.htm&type=5)