Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Bullet at start of arrayjoin

Topic Labels: Formulas
Solved
Jump to Solution
833 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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.

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