Print this page

How do I create a formula that shows the value(s) of a multi-select picklist?

Knowledge Article Number 000004260
Description

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.

Resolution

To achieve this result, you can create a formula using syntax like the example below.

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 )

 

 

 





promote demote