JOIN function is not working from a different sheet

Options

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,

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!