+ Start a Discussion
S PraveenS Praveen 

Assigning a multipicklist value to Formula field

Hi,

 

I have one requirement i.e., i want to give a multipicklist field in formula field but it is not accepting,

 

for picklist field we declare as TEXT(picklist field) in the formula field.but for multi-picklist field this type is not accepting.

 

 

Please help me as this is very urgent.

 

 

Regards,

Praveen

Best Answer chosen by Admin (Salesforce Developers) 
RArunrajRArunraj

Hi Praveen,

 

You can also use the below formula to achieve multipicklist value to Formula field

 

Multi Pick List value contains Sample A, Sample B, Sample C as value

 

IF(INCLUDES(MultiPickList__c, "Sample A"),"Sample A;","") 

IF(INCLUDES(MultiPickList__c, "Sample B"),"Sample B;","") 

IF(INCLUDES(MultiPickList__c, "Sample C"),"Sample C;","")

 

Thanks,

Arunraj

All Answers

RArunrajRArunraj

Hi Praveen,

 

Multi-select picklist fields can only be used in the following functions IN FORMULA FIELD:

INCLUDES

ISBLANK

ISNULL

 

So for this what i suggest is

 

1. Create one more text field and do a field update from the MultiSelect Picklist value to newly created Text field using a after insert,after update Trigger

 

2. Then assign the new Text field value to the formula field and hide the newly created field from the pagelayout

 

Thanks,

Arunraj

 

RArunrajRArunraj

Hi Praveen,

 

You can also use the below formula to achieve multipicklist value to Formula field

 

Multi Pick List value contains Sample A, Sample B, Sample C as value

 

IF(INCLUDES(MultiPickList__c, "Sample A"),"Sample A;","") 

IF(INCLUDES(MultiPickList__c, "Sample B"),"Sample B;","") 

IF(INCLUDES(MultiPickList__c, "Sample C"),"Sample C;","")

 

Thanks,

Arunraj

This was selected as the best answer