ARRAYJOIN(ARRAYCOMPACT())

[n0xp]

Hi everyone,

I'm trying to get this formular to work, and although it parses there's no output.

ARRAYJOIN(ARRAYCOMPACT(Field1,Field2,Field3,Field4), ", ")

The fields are a mix of and link-to-another-record fields lookups (of link-to-another-record fields) where the outputs all are fine. The reason why I'm using an ARRAYCOMPACT as well is because half of the fields are usually empty.

Thank you very much ❤️

[n0xp · Accepted solution]

Solved by myself.

For anyone ever in the same boat as I was. ARRAYFLATTEN() by itself combined all not empty fields with commas in between. ❤️