+ Start a Discussion
Ketan Solanki29Ketan 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.
 
Best Answer chosen by Ketan Solanki29
HARSHIL U PARIKHHARSHIL U PARIKH
You can make a use of INCLUDE function in salesforce,
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

RD@SFRD@SF
Hi Ketan,
Follow this link
https://success.salesforce.com/answers?id=90630000000gv5cAAA

Hope it helps
RD
HARSHIL U PARIKHHARSHIL U PARIKH
You can make a use of INCLUDE function in salesforce,
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!
This was selected as the best answer
Ketan Solanki29Ketan Solanki29
Can we directly get this multiple values(picklist field) separted by comma under the Text formula ? This is not prpper solution if we add new value to picklist field then we must need to update formula field as well.
HARSHIL U PARIKHHARSHIL U PARIKH
I understand but I am not sure if there is a way around it yet.

And here we go: https://success.salesforce.com/ideaview?id=08730000000JobAAAS