JOIN forumla help

Here is a pic of my sheet. I'm trying to find a way to identify a specific CHILDREN row. I thought that using JOIN to bring together the columns that are unique would give me something to refer to to identify a specific CHILDREN row. I'm trying to JOIN the PL##### with the GRANDCHILD under Deliverable Name and Assets. The result I'm looking for is:

PL25148,Request Received and PL25148,Copyediting

However, my JOIN formula isn't working. Any thoughts?

Screen Shot 2020-06-20 at 8.26.48 PM.png

Find more posts tagged with

Accepted answers

Genevieve P.

Hi Jeana,

Instead of using JOIN, try just adding the cells together, with a comma between:

=PARENT([Asset #]@row) + " , " + [Deliverable Name and Assets]@row

If there is no parent it could look a little funny as the comma will start the cell, so we could add an IF statement around for if the Parent isn't blank. Let me know if you want help with this, or if the above formula works for you!

Cheers,

Genevieve

All comments

Genevieve P.

Hi Jeana,

Instead of using JOIN, try just adding the cells together, with a comma between:

=PARENT([Asset #]@row) + " , " + [Deliverable Name and Assets]@row

Cheers,

Genevieve

Jeana

Good idea! Don't know why I keep over thinking these formulas. :-)

Thanks!

Jeana

Genevieve P.

Haha no problem! I do that all the time, too. 🙂

Sign in to join the conversation!

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.