Referencing a specific level in a hierarchical setup

Hello,

I am trying to do a count of statuses on a sheet but I need it at the second child level. In many cases there are children below this level also that I want excluded, and I also do not want to include anything from the parent levels above either. I do have a helper column that assigns a number code to each row with a period denoting a new step in (top row is 1, first child is 1.1, first child of that child is 1.1.1, so on and so on).

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

I would insert a helper column that outputs the level

=COUNT(ANCESTORS())

Then you can leverage this in whatever other formula you are using to evaluate the levels.

=COUNTIFS(………………….., Level:Level, @cell = 2)

All comments

Paul Newcome

I would insert a helper column that outputs the level

=COUNT(ANCESTORS())

Then you can leverage this in whatever other formula you are using to evaluate the levels.

=COUNTIFS(………………….., Level:Level, @cell = 2)

Mross0878

That worked perfectly, thank you so much Paul!

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.