Skip to main content
Topics#Data ManagementJackie Travieso's Question
Jackie Travieso asked in #Data Management
Sep 16, 2011, 6:24 PM

Formula Field (Text): Multi-select Picklist

What would the formula look like if I wanted to 'copy & paste' a value from a multiple select picklist from one object to another?

 

I tried this, but I get an error message.

 

TEXT( Opportunity__r.CPC__c )

 

Error msg:

 

CPC is a multi-select picklist field. Multi-select picklist fields are only supported in certain functions.
266 answers
  1. Steve Molis (You Owe Me a Beer, Inc.)
    Sep 16, 2011, 7:00 PM
    Thanks @JackieT 

     

    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)

Write an answer...
0/9000