How? Column Formula to Pull Level 1 Parent Task Name

Hi Smartsheet Community,

Please see image of setup! I am trying to create a column formula for the column 'TEST' that pulls the name of the Level 1 parent task for each row. Essentially, I want every cell in the 'TEST' column to display the name of its Level 1 parent, such as "baseline estimate" or "estimate R1," depending on which is their Level 1 parent task. I would like to be able to differentiate between estimate iterations for every child task within that section.

Is there a way to set up this formula in Smartsheet so that it automatically pulls the top-level parent task name for each row?

Thanks in advance for your help!

Find more posts tagged with

Formulas

Automations

columns

Accepted answers

All comments

John_Foster

Hi @gabbim,

I believe that the following formula is what you are looking for.

=INDEX(ANCESTORS([Task Description]@row), 1)

The one at the end determines which level you would like displayed.

Hope this helps!

Thanks,
John

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.