JOIN function is not working from a different sheet

OshaK

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,

Paul Newcome

When referencing a different sheet, you would only input the cross sheet reference a single time.

=JOIN({Cross Sheet Reference}, CHAR(10))

OshaK

thank you @Paul Newcome I only need to join a few columns, not the entire row. Is it possible?

Paul Newcome

Are you able to provide some screenshots of both sheets with sample data to show exactly what you are wanting to accomplish?