Giving a Parent Row a level score

Is it possible to give a parent row a score based on its hierarchy in the row grouping? ie The top level of grouping being level 1, next level of grouping level 2, but only where the row is a parent?

I am currently using =COUNT(ANCESTORS()) but this gives a task a score even if it doesnt have a child.

It would be great to return a level like in the image below.

I have seen it done before but its been a while and cant remember. If anyone could help, it would be appreciated.

Thanks.

Find more posts tagged with

Accepted answers

Nick Korna

Hi @RobS,

This formula should do what you're after:

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

Using your example data:

Hope this helps, but any problems/queries then just post! 🙂

All comments

John_Foster

Hi @RobS,

You could use an IF statement where you use "COUNT(CHILDREN) > 0" as the logical expression to see if it has children and where the answer is true use your logic, where false you can use "" to leave the row empty.

Hope this helps!

John

Nick Korna

Hi @RobS,

This formula should do what you're after:

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

Using your example data:

Hope this helps, but any problems/queries then just post! 🙂

RobS

https://community.smartsheet.com/discussion/comment/407963#Comment_407963

Perfect, thank you Nick.

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.