Loading

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

Publiseringsdato: Apr 3, 2026
Beskrivelse
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-artikkelnummer

000381324

 
Laster
Salesforce Help | Article