You need to sign in to do that
Don't have an account?
Ellsa 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.
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.
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.
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
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,