Get Multi-Select Picklist displayed with bullet point and separate lines (instead of semicolon separated)

on

Suppose the multiselect picklist field we have is named sampleMultiselectPLField__c(API name)


Create a formula field with return type as Text -


IF(ISBLANK(sampleMultiselectPLField__c), NULL, 

IF(INCLUDES(sampleMultiselectPLField__c, "1"), "• 1" + BR() , NULL) + 

IF(INCLUDES(sampleMultiselectPLField__c, "2"), "• 2" + BR() , NULL) + 

IF(INCLUDES(sampleMultiselectPLField__c, "3"), "• 3" + BR() , NULL) + 

IF(INCLUDES(sampleMultiselectPLField__c, "4"), "• 4" + BR() , NULL) + 

IF(INCLUDES(sampleMultiselectPLField__c, "5"), "• 5" + BR() , NULL) + 

IF(INCLUDES(sampleMultiselectPLField__c, "6"), "• 6" + BR() , NULL) + 

IF(INCLUDES(sampleMultiselectPLField__c, "7"), "• 7" + BR() , NULL))



Comments

Post a Comment