You need to sign in to do that
Don't have an account?
Multi-picklist in a formula field
In a child object I want to have a forumla field that should display the selected mult-picklist values present in the parent object.
How can I do it? I am not able to use the merge field directly or using any of the available functions including text()
Thanks in advance
You can't display the values of a multi-select picklist in a cross-object formula or standard formula field at the present time and I'm not sure if Salesforce is planning to address this in the upcoming Winter '10 release.
The only option would be to capture the values of the multi-select picklist in a text field using an Apex trigger and then display that field on the child record.
Do you know if this was delivered? If not, can you point an Apex greenhorn to some information to help me out?
Here's a summary of my situation to give you all the facts:
Summary: Pretty simple...I need to convert the results for the multi-select picklist to a simple text field via formula logic.
Problem: The TEXT(____) formula logic does not work with MS picklists as it does for the normal picklists. I am fine with the semicolon delimited format produced when creating custom reports with this data type, but cannot get this behavior.
Background: I am implementing our app for a client that needs to take the MS picklist value off of the opportunity (parent object) down to the related Invoice object.
Any help would be awesome and see y'all at Dreamforce.