Auto-assign # based on parent or child (sub-item)

I looking for a formula to auto-assign a number based on the parent/child level.

For example, first level parent would be auto-assigned zero (0). Any sub-items would then be 1, 2, 3, etc. based on what level the item is listed under the parent. I've provided an example of how this would look, but I've manually entered in the 0,1,2,3, etc. in the 'Level assignment" column. I'm looking for a formula to replace the numbers in that column so I don't have to manually enter them when new rows and children are added to parents.

Thank you!

Find more posts tagged with

Formulas

Accepted answers

Lauren Kleitz

I don't see your attachment but if you are looking for any parent row to be a 0, any sub task to be a 1, any sub-subtask to be a 2, and so on, this formula should work:

=Count(Ancestors())

Let me know if that helps or if you are looking for something different!

All comments

Lauren Kleitz

I don't see your attachment but if you are looking for any parent row to be a 0, any sub task to be a 1, any sub-subtask to be a 2, and so on, this formula should work:

=Count(Ancestors())

Let me know if that helps or if you are looking for something different!

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.