Pulling Parent Task Name and Child name to New Column

Hello!

I am trying to populate a new column that includes the parent and child task names together. Ideally the column would work in this format:

Parent Task

Parent Task - Child Task 1

Parent Task - Child Task 2

I tried using this formula: =PARENT([Project (Level 1)/Task or Milestone (Level 2)]@row) + " - " + [Project (Level 1)/Task or Milestone (Level 2)]@row

But that pulls in the - at the front of the parent task in the new column. is there a formula format that would only pull the - in when there is a child task after the parent?

Find more posts tagged with

Accepted answers

Ray Lindstrom

Hi @kendallmar,

Let's try wrapping it in an IF statement, so it only uses the delimiters when there is a parent:

=IF(COUNT(ANCESTORS()) > 0, JOIN(ANCESTORS([Primary Column]@row), " - ") + " - " + [Primary Column]@row, [Primary Column]@row)

BRgds,

-Ray

All comments

Ray Lindstrom

Hi @kendallmar,

Try this:

=JOIN(ANCESTORS([Primary Column]@row), " - ") + " - " + [Primary Column]@row

Replace the two instances of the name "Primary Column" with your own Primary Column name.

Alternately you could also replace delimiter I used which is " - " with another like " , " if you would like a comma instead of a dash in-between values.

BRgds,

-Ray

kendallmar

@Ray Lindstrom

I tried that formula but it is still pulling in a - in before the parent task, but it is correct for the child rows. The column looks like this now

the column on the left is the new Task name column I would like to us for filtering and the column on the right is the existing task name column

Ray Lindstrom

Hi @kendallmar,

Let's try wrapping it in an IF statement, so it only uses the delimiters when there is a parent:

=IF(COUNT(ANCESTORS()) > 0, JOIN(ANCESTORS([Primary Column]@row), " - ") + " - " + [Primary Column]@row, [Primary Column]@row)

BRgds,

-Ray

kendallmar

https://community.smartsheet.com/discussion/comment/402532#Comment_402532

That worked!! Thanks so much for your help!!

Ray Lindstrom

Glad to hear it worked!

Happy to help.

Best of luck to you in your solutioning!

Mark Rothfield

Thanks Ray, that was super helpful.

Ray Lindstrom

Hi @Mark Rothfield,

It's my pleasure. Glad you found it useful.

BRgds,
-Ray

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.