Concatenate from List

So you can โ€œSPLIT()โ€ a structured text based list. Can you โ€œCONCATENATE()โ€ from a list?

I want to display values in a single virtual text field from a โ€œSELECT()โ€ list of values. Can I aggregate values from a list into a single test field?

2 5 1,625
5 REPLIES 5

Steve
Platinum 4
Platinum 4

Sure!

Cool, thanks. I was looking for some type of delimiter selection on the concatenate side to make it work, but I guess it is unnecessary. Shouldโ€™ve just tried it. Thanks anyway.

VBBA
New Member

I am looking for exactly this function to convert multiple items from a different table into displaying in a virtual text column.

However, appsheet seems to only convert one random value from the list:

Ideally I would like to convert all values, delimited by โ€œ,โ€. Is there a way to do this?

VBBA
New Member

It works when I use this expression in the formula:

CONCATENATE(SELECT(ServicetoTech[TechID], [_THISROW].[ServiceID]=[ServiceID]))

Hello @VBBA , that is because VLOOKUP() only returns a single value given the search criteria, while SELECT() would pull a filtered list, which is then concatenated.

Top Labels in this Space