Reporting on Multi Select fields

Did you ever find a solution for this? I would like to do the same thing. :) Sheri Whitten Gordon Food Service

This article gives the codes - but i don't know the syntax to use these. Anyone can help by showing an example of how to use these in text mode. View this on Workfront > Benetta Perry APS

Tricky One :) displayname=Systems List linkedname=direct namekey=Systems Effected textmode=true valueexpression=REPLACE({DE:Systems Effected},","," \ \ u000A") valueformat=HTML So you need to replace the commas in your string with the unicode character u000A. To escape into the unicode character you need two \ \ without a space. It will save as only one \ so you'll need to add back the second slash each time you edit to prevent the interpreter from inserting the line break in the text mode instead of in the column. Melinda Layten Technical Project Manager - API and Integration Workfront

Very nice Melinda, That one looks like it might have been a morning's worth of noodling. It's going in the vault. Thanks for sharing. Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

Just noticed, switching from valuefield to valueexpression is sorting the list alphabetically! Underlying field isn't sorted at all. Melinda Layten Technical Project Manager - API and Integration Workfront

I noticed that too: bonus! Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

I've added "https://wf-pro.com/textmode/text-mode-views-collections/#multiselect-list"> Multi-Select as Alphabetized List to the WFPro site. Thank you for sharing Melinda!

Thank you, I have switched to valueexpression from valuefield to sort multi-select values alphabetically but after the switch i am unable to inline edit the field. Is there any solution to inline edit the field in a view/report at the same time sort the multi selected values? Thanks, Pradeep Pradeep Sundharagiri Deere GIT

No you can not edit any field that uses a valueexpression. For that you need to stick to the standard list. Melinda Layten Technical Project Manager - API and Integration Workfront

Nifty! I'm working on a custom form that will be used to assess a requests relevance / priority. In that custom form I need to have several fields that collect multi-select values that get stored as numbers. Something like: What product requires this piece? Product A is equivalent to 5 points Product B is equivalent to 4 points Product C is equivalent to 3 points Product D is equivalent to 2 points Product E is equivalent to 1 point A user might select Product A and Product D. I hoped to be able to add the selected values up using the SUM function in a custom field, but that seems to grab the first item picked from the list and ignore every other option selected. Anyone done something similar? Ideas? Rick MacDuffie Symetra Life Insurance Company