Need help with Listcombine() inside of a Concatenate()

Hey guys, I’m really stumped here and not sure how to get the display value I want. It should be all lined out in this doc. Could really use some guidance as to 1. how to get the value I want, and 2. why does the concatenate remove the ", " between my lists

Hi! In the column Get to Display Properly inside a Concatenate() [NOT WORKING], wrap the variable Combine Both (Multi and the Single Columns) in the list() function.

Concatenate(list(thisRow.[Combine Both (Multi and the Single Columns)])," is my list")
2 Likes

As well as ListCombine() formula, there is also the Join(aList, aSeparator) formula.
So you can construct a text listing of your list elements, separated by comma+space or any other separator string you like.

2 Likes

Join is, by the way, really helpful for building JSON strings.

2 Likes