Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Rollup ArrayUnique but Format as Bullets

Solved
Jump to Solution
1899 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Jason_Friedlan1
6 - Interface Innovator
6 - Interface Innovator

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?

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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- ")
)

See Solution in Thread

3 Replies 3
kuovonne
18 - Pluto
18 - Pluto

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- ")
)

To return a 'bullet point' list use the following alternative formula in the rollup.

IF(
  ARRAYJOIN(ARRAYUNIQUE(values), " • "),
  " • " & ARRAYJOIN(ARRAYUNIQUE(values), "\n • ")
)

  

Thanks for sharing the bullet character. 

I tend to use the - character because it is easier to type on the fly, and I started using it as a bullet several decades ago. Also, the - character is Markdown for a bullet, which is helpful when copying a formula result to a rich text field.