Formula to ID indent level

I am trying to perfect a formula that I am currently using to make it a bit more robust.

Currently the formula I am using to ID indent level is:

=IF(COUNT(CHILDREN([Job Name]@row)) > 0, COUNT(ANCESTORS()) + 1)

This works until I end up with grandchild rows. Below is a screenshot of a sheet to better articulate what I am after.

Main reason for this is for sorting as currently when we sort by the primary column, the child/grandchild rows become a jumbled mess.

Find more posts tagged with

Accepted answers

All comments

Bassam Khalil

Hi @Travis Myers

Hope you are fine, @Tom Zylstra had created a very good solution for Work Breakdown structure, please check his post i think you will find a great help for your case:

Work Breakdown Structure (WBS) - Column Formula Configuration

Will Kremer

Hi @Travis Myers,

I am a little late here but I took your initial statement and added a value for if it is false (so fi the children rows are not greater than 0) and it seems to be working for my grandchild rows now. Hope you found a solution in the meantime but if not I hope this helps!

=IF(COUNT(CHILDREN(Deliverable@row)) > 0, COUNT(ANCESTORS()), COUNT(ANCESTORS()))

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.