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]), " ")
B...