Loading

Multi-Select Picklists Not Available in Salesforce Reporting Snapshots

Fecha de publicación: May 21, 2026
Descripción

It is not currently possible to utilize a multi-picklist field within a Reporting Snapshot.  Because multi-select picklist fields can have multiple selected values, it is not possible to report on a single value from a picklist field.  

 

Solución

As a workaround, create a Formula field for every picklist value to report on each selection.  The formula fields can then be mapped in the Reporting Snapshot creation.


For example, if the multi-select picklist field is called School, and the available values are Class 1, Class 2, and Class 3, and you want to see each time one of these options is selected, you'll need to create a Formula field for each option. The formulas would look like this:
 
Class 1:  IF(INCLUDES(School__c, "Class 1"), "Class 1","NA")
Class 2 : IF(INCLUDES(School__c, "Class 2"), "Class 2","NA")
Class 3 : IF(INCLUDES(School__c, "Class 3"), "Class 3","NA")

 

Recursos adicionales

For more information on Reporting Snapshots, visit the Salesforce Help Report on Historical Data with Reporting Snapshots.

See the Salesforce Article Create a formula that shows the value of a multi-select picklist from a parent to a child object for additional formula details. 

Número del artículo de conocimiento

000384581

 
Cargando
Salesforce Help | Article