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

June 8, 2011
·
Like
0
·
Follow
0

Best Answer chosen by Admin (Salesforce Developers)

RArunraj
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

June 8, 2011
·
Like
0
·
Dislike
0

RArunraj
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

June 8, 2011
·
Like
0
·
Dislike
0

Browse by Topic

Welcome to Support!

Show

sorted by

Assigning a multipicklist value to Formula field

All Answers

You need to sign in to do that.