We need to create a formula field on a child object that displays all of the selected values from a multi-select picklist on the parent object.
In order to create a formula field on a child object that displays all of the selected values from a multi-select picklist on the parent object, perform the following:
Create a formula field on the Object in Salesforce Classic or Lightning Experience
1. Go to the object where you want to create the field
Salesforce Classic : Setup | Customize | Object | Fields
Lightning Experience: Gear Icon | Setup | Object Manager | Object | Fields & Relationships
2. Click New.
3. Select Formula for the Data Type.
4. Name the field and select Text for the Formula Return Type.
5. Click Next.
6. Enter your formula syntax.
IF ( INCLUDES ( parent.multipicklist__c , "Value 1" ), "Value 1; ",null ) &
IF ( INCLUDES ( parent.multipicklist__c , "Value 2" ), "Value 2; ",null ) &
IF ( INCLUDES ( parent.multipicklist__c , "Value 3" ), "Value 3; ",null ) &
IF ( INCLUDES ( parent.multipicklist__c , "Value 4" ), "Value 4; ",null ) &
IF ( INCLUDES ( parent.multipicklist__c , "Value 5" ), "Value 5; ",null )
This example would produce return values such as:
Value 1; Value 2; Value 3; Value 4; Value 5;
Value 1; Value 4; Value 5;
Value 2; Value 5;
Value 4;
Other separators can be used or BR() instead of separator characters to list return values on separate lines, such as:
Value 1
Value 4
Value 5
Note: While it's possible to show the contents of a multi-picklist field using the formula shown in this resolution, there is currently an Salesforce Idea to make this standard functionality with the help of the existing TEXT() function. Visit and vote for the Idea to Support TEXT () function to convert "Multi-select picklist" to "Text"
Related Documentation:
Tips for Working with Picklist and Multi-Select Picklist Formula Fields
000384832

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.