Rollup ArrayUnique but Format as Bullets

[Jason_Friedlan1]

Hey Guys:

Is there a way to take the result of a rollup that is comma separated and then convert it to a bulleted list in another field?

[kuovonne · Accepted solution]

Formula and rollup fields only show text as plain text, so bulleted lists are not available.

However, you can fake a bulleted list by using a text character such as - or * in front of each line.
To do this, I recommend creating the list in a rollup directly. (If you can’t alter the existing rollup, create a new one.)

IF(
  ARRAYJOIN(values),
  "- " & ARRAYJOIN(values, "\n- ")
)