Skip to main content

I have a table with a few optional text fields, and want to create a formula column that concatenates the existing values in those fields with a space separator. It would be great to do this as:


ARRAYJOIN(ARRAYCOMPACT([Field1,Field2,Field3]), " ")

But this results in an error, presumably because the array functions are used outside of a rollup column, or because array literals composed of field names is not supported.


The workaround for this is very nasty, requiring a lot of IFs in order to test whether each field is populated before adding the space separator. More flexibility with array literals and array functions could be really useful in a variety of text situations.

Be the first to reply!

Reply