+ Start a Discussion
Rahul Reddy 6Rahul Reddy 6 

How would I pass a Multi Select picklist value on account to opportunity as a non editable field?

I have a requirement that the custom filed in account is Multi Sellect Pick list and i need to pass multi select picklist values on account to opportunity as a non editable field?

Can you guys help me with this? Any hlep is highly appreciated.
Best Answer chosen by Rahul Reddy 6
BalajiRanganathanBalajiRanganathan
you can create a formula field on Opportunity.

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

https://success.salesforce.com/answers?id=90630000000gv5cAAA

All Answers

BalajiRanganathanBalajiRanganathan
you can create a formula field on Opportunity.

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

https://success.salesforce.com/answers?id=90630000000gv5cAAA
This was selected as the best answer
Rahul Reddy 6Rahul Reddy 6
Thank you so much Balaji Ranganathan for your quick response. Appreciate it.
Rahul Reddy 1Rahul Reddy 1
Balaji Ranganathan,

Thanks for the help. Now i need a little more help, i know i am changing the requirement a bit here.

I have a "Close Reason" custom multi picklist field in Accounts and i need the same in Opportunities. However if anything is updated in Accounts it should reflect in Opportunities which can be acheived by the above solution you gave. But, i would like the multi picklist in editable form in opportunities and what is edted should be updated in accounts and vice versa in short i need to map those two custom picklist fields. But the map option is not available in view fields page of accounts / opportunities unlike which is available in Lead so is there another way to do it.

Appreciate all the help