+ Start a Discussion
Ellsa JamesEllsa James 

How do I write a cross object formula to copy multi-picklist values?

I am using the below syntax which I have seen posted as a solution but I am getting an error.

IF( INCLUDES(Service_Engineer__c, "Alan Clarkson"), "Alan Clarkson; ","")
&
IF( INCLUDES(Service_Engineer__c, "Alan Eadie"), "Alan Eadie; ", "")
&
IF( INCLUDES(Service_Engineer__c, "Dave Matthews"), "Dave Matthews; ", "")
&
IF( INCLUDES(Service_Engineer__c, "Dean Hunt"), "Dean Hunt; ", "")
&
IF( INCLUDES(Service_Engineer__c, "Paul Beddard"), "Paul Beddard; ", "")
&
IF( INCLUDES(Service_Engineer__c, "Paul Levay"), "Paul Levay; ", "")
&
IF( INCLUDES(Service_Engineer__c, "Richard Hatch"), "Richard Hatch; ", "")
&
IF( INCLUDES(Service_Engineer__c, "Veritek"), "Veritek; ", "")
&
IF( INCLUDES(Service_Engineer__c, "Dave Beswick"), "Dave Beswick; ", "")

The error I am getting is Error: Incorrect parameter type for function 'INCLUDES()'. Expected Picklist, received Text

I am positive the field "Service_Engineer__c" is a multi-Picklist field so i do not know why I am getting this error.

Grazitti TeamGrazitti Team
Hi,

you could try something like this:

IF(INCLUDES( Multi_Picklist_1__c , "A"), "A", NULL)  + BR() +
IF(INCLUDES( Multi_Picklist_1__c , "B"), "B", NULL)  + BR() +
IF(INCLUDES( Multi_Picklist_1__c , "C"), "C", NULL)


Please Mark this as Answer if it helps you
--
Regards,
Grazitti Team
Web: www.grazitti.com
Email: sfdc@grazitti.com
Hector DiazHector Diaz
Hi
see this example, the trick it's refence field "IF(INCLUDES(Opportunity__r.LineItemBrands__c,"TRENDMICRO"),"TRENDMICRO;",NULL)+"
Opportunity__r  its the object Oportunity
LineItemBrands__c it's the mtultipicklist field
TRENDMICRO it's a multipicklist value

IF(INCLUDES(Opportunity__r.LineItemBrands__c,"Cetis-Teledex"),"Cetis-Teledex;",NULL)+
IF(INCLUDES(Opportunity__r.LineItemBrands__c,"VMWare"),"VMWare;",NULL)

BEST,