Skip to main content
Jackie Travieso 님이 #Data Management에 질문했습니다
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개
  1. 2011년 9월 16일 오후 7:00
    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)

0/9000