Help

Bullet at start of arrayjoin

Topic Labels: Formulas
Solved
Jump to Solution
1349 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Danny_hearn
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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

See Solution in Thread

2 Replies 2
Zollie
10 - Mercury
10 - Mercury

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.

kuovonne
18 - Pluto
18 - Pluto

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