Solved

Bullet at start of arrayjoin

Hello…
I’m using a rollup with ARRAYJOIN(values,"\n • ")

Which is giving me this result

Item 1
• Item 2
• Item 3

I want this result
• Item 1
• Item 2
• Item 3

How do I create a formula that puts a bullet on first item?

Best answer by kuovonne

To avoid an extra bullet if there are no records, put the initial bullet in an IF statement:

IF(COUNTA(values) >= 1, "• ") & ARRAYJOIN(values,"\n• ")

+18

This will kind of do what you’re describing:
"• " & ARRAYJOIN(values,"\n• ")

But it’ll display that first • even if no records were linked - so it’s not the cleanest solution.

ARRAYJOIN isn’t really intended for bullet points. It’s meant to create comma separated lists and the like.

+29

To avoid an extra bullet if there are no records, put the initial bullet in an IF statement:

IF(COUNTA(values) >= 1, "• ") & ARRAYJOIN(values,"\n• ")

Sign up