Loading

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

Publiceringsdatum: Apr 3, 2026
Beskrivning
You cannot create a formula field that references a Picklist (Multi-select) field value using the API name of the field only.
Lösning

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)


Expected results on the formula field:

  • Apple
  • Banana
  • Coconut


Note: Advisable for picklists with less number of values.


Knowledge-artikelnummer

000381324

 
Laddar
Salesforce Help | Article