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