Loading

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

Дата публикации: Apr 3, 2026
Описание
You cannot create a formula field that references a Picklist (Multi-select) field value using the API name of the field only.
Решение

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.


Номер статьи базы знаний

000381324

 
Загрузка
Salesforce Help | Article