Help

Re: Concatenate multiple fields separated by commas without string of commas at end

Solved
Jump to Solution
2815 1
cancel
Showing results for 
Search instead for 
Did you mean: 
shelby_jackson
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello! I am currently using the below formula to pull together a list of cities that correspond to a record. I have City 1, City 2, City 3, City 4, City 5, Cities 6 fields. Formula looks like this:

CONCATENATE({BP City 1}, ", ",{BP City 2}, ", ",{BP City 3}, ", ",{BP City 4}, ", ",{BP City 5}, ", ",{BP Cities 6})

My formula works if all 6 fields contain cities although it doesn’t look great if only one city is listed. It ends up looking like this:

Philadelphia, , , , ,

Anyone know how to fix the formula so that the appropriate number of commas appear so there will not be a string of messy commas at the end?

Thank you!

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

See Solution in Thread

3 Replies 3
kuovonne
18 - Pluto
18 - Pluto
shelby_jackson
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you so much, @kuovonne! :heart_eyes:

So helpful!  Stumbled across this and it worked like a charm.... 🙂