Print this page

Formula to duplicate values from Multi-Select picklist field

Knowledge Article Number 000239961
Description

If you're trying to duplicate values from a multi-select picklist and are running into trouble, be careful of the syntax that's being used.

Resolution

While creating a Formula for Multi-Select picklist, we should use the "INCLUDES" or "CONTAINS" Function.
 

Example syntax to use for Multi-Select picklist

IF(INCLUDES( Multi_Picklist_1__c , "A; "), "A", NULL) + ;
IF(INCLUDES( Multi_Picklist_1__c , "B; "), "B", NULL) + ;
IF(INCLUDES( Multi_Picklist_1__c , "C; "), "C", NULL)




promote demote