Hierarchy Formula Help

Hi Everyone, thank you in advance for your help on this issue.

Currently I have a level column that gives you a number based on the level of the hierarchy the row is assigned to. I am trying to implement a column called "Topic" that lists the Task Name for Level 0 of the hierarchy for all of the children rows.

My formula:

=IF(Level@row = 0, Task@row, IF(Level@row > 0, INDEX(Task:Task, MATCH(0, Level:Level, 0)), ""))

This formula is repeating the Task name for the first level 0 task in the sheet instead of the most recent level 0 parent row for the given child.

Does anyone have any ideas for a solution?

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try this:

=IF(Level@row = 0, Task@row, INDEX(ANCESTORS(Task@row), 1))

All comments

Paul Newcome

Try this:

=IF(Level@row = 0, Task@row, INDEX(ANCESTORS(Task@row), 1))

NRJW53

@Paul Newcome Thank you so much for the help!

Paul Newcome

Happy to help. 👍️

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.