You need to sign in to do that
Don't have an account?
Ketan Solanki29
Multi-picklist value getting error in Formula Field
Hell Team,
I have "Product Type" Multi-Picklist field on Opportunity Object. Have another OpportunityProduct__c Custom Child object of Opportunity where i am creating "Product Type" using Text Formula field but i am getting error while accessing parent Opportunity objects Product Type Multi-Picklist field.
TEXT(Opportunity.Product_Type__c)
ERROR : Field Product_Type__c is a multi-select picklist field. Multi-select picklist fields are only supported in certain functions.
Please help me to reslove this error.
I have "Product Type" Multi-Picklist field on Opportunity Object. Have another OpportunityProduct__c Custom Child object of Opportunity where i am creating "Product Type" using Text Formula field but i am getting error while accessing parent Opportunity objects Product Type Multi-Picklist field.
TEXT(Opportunity.Product_Type__c)
ERROR : Field Product_Type__c is a multi-select picklist field. Multi-select picklist fields are only supported in certain functions.
Please help me to reslove this error.
Try using something along following lines,
IF(INCLUDES( Product_Type__c, "TYPEA"), "TYPEA", NULL) + BR() +
IF(INCLUDES( Product_Type__c, "TYPEB"), "TYPEB", NULL) + BR() +
IF(INCLUDES( Product_Type__c, "TYPEC"), "TYPEC", NULL)
+
+
+
do this for all the possible types..
Hope this helps!
All Answers
Follow this link
https://success.salesforce.com/answers?id=90630000000gv5cAAA
Hope it helps
RD
Try using something along following lines,
IF(INCLUDES( Product_Type__c, "TYPEA"), "TYPEA", NULL) + BR() +
IF(INCLUDES( Product_Type__c, "TYPEB"), "TYPEB", NULL) + BR() +
IF(INCLUDES( Product_Type__c, "TYPEC"), "TYPEC", NULL)
+
+
+
do this for all the possible types..
Hope this helps!
And here we go: https://success.salesforce.com/ideaview?id=08730000000JobAAAS