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,

Find more posts tagged with

Accepted answers

All comments

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.