Formula field based on picklist 'multi-select' field values.

This resolution explains how to build a Salesforce formula field that displays the selected values of a Picklist (Multi-Select) field, since referencing the field by its API name alone is not supported.

Sample Formula

Here is a sample formula you can build on:

IF(INCLUDES( Multi_Picklist_field__c , "Apple"), "Apple" + BR(), NULL) +
IF(INCLUDES( Multi_Picklist_field__c , "Banana"), "Banana" + BR(), NULL) +
IF(INCLUDES( Multi_Picklist_field__c , "Coconut"), "Coconut", NULL)

This formula checks the Multi_Picklist_field__c field for each possible value ("Apple", "Banana", "Coconut") using the INCLUDES function, and if that value is selected, includes it on its own line in the formula field's output.

Expected Result

If a record has all three values selected on the multi-select picklist, the formula field displays:

• Apple

• Banana

• Coconut

When to Use This Approach

This approach is best suited for picklists with a small number of values, since each value requires its own INCLUDES condition in the formula. For picklists with many values, consider Salesforce's other supported approaches for working with multi-select picklists in formulas.