My Rollup field has (correctly) returned this array to me ARRAYJOIN(values) by looking at linked records (4 People) and their dietary requirements (dietary preferences are determined by a multiple select field):
None,Allergy to Nuts (other than Peanuts),Gluten-free / No beef / Allergy to Nuts (other than Peanuts),None
Another formula field formats this array into an easier to read arrangement:
1 x None
1 x Allergy to Nuts (other than Peanuts)
1 x Gluten-free / No beef / Allergy to Nuts (other than Peanuts)
1 x None
What I would really like is to find a way to combine any duplicated items and show the correct count for them, such as:
2 x None
1 x Allergy to Nuts (other than Peanuts)
1 x Gluten-free / No beef / Allergy to Nuts (other than Peanuts)
Any advice on how to do this please? I want any formula to work dynamically with the content of the array, as this will make it easier to update the multiple select options without needing to rewrite any formulas that contain verbatim references to each and every multi-select text entry.
