JOIN function is not working from a different sheet


I need to combine the cell values from a different sheet in a new sheet. When I add this formula into the source sheet, it's working fine:

=JOIN([Additional Date 1]@row:Comments@row, CHAR(10))

but when I reference the source sheet from a different sheet and i want to JOIN the column values:

=JOIN({[Additional Date 1]}:Comments, CHAR(10))

it returns UNPARSEABLE. I think I tried every possible combination of the brackets and can't get it to work.

thank you,


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!