We have a form our users fill out that requires selecting a few entries from a long list of items, which we've managed to clean up by storing items by organization name--each organization has its own multi-select field, and they're conditional upon that organization being selected, so the form works nicely on the front end.
On the backend, we have a bit of a mess. There are nearly 100 organizations, and every one of them has a field. In order to easily collect the items that users are selecting, we have a formula field that concatenates every organization field. It's basically:
{AA} & {BB} & {CC}which returns the selected values in whichever field.
The problem is that the multiselect fields don't all behave the same with the concatenation. Sometimes they produce a comma and space between them. Sometimes they don't. My goal is to clean this up for our user facing team in our automated email notification to show which items they've selected in a nice, bulleted list.
Any ideas?