Formula to Check a box at different indention levels

Hey there,

Trying to figure out a formula to automatically check the boxes based on how many times a task has been indented, like this:

Screen Shot 2021-04-19 at 2.51.08 PM.png

I know I can set the Activity column to: =IF(COUNT(CHILDREN([Task Name]@row)) = 0, 1), but I don't know how to do the others. Any help would be appreciated!

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Instead of counting children, count ancestors. The leftmost indentation will result in a zero from the COUNT.

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

would be for the Department column.

1 would be for the Category column, 2 for the Initiative column, so on and so forth.

All comments

Paul Newcome

Instead of counting children, count ancestors. The leftmost indentation will result in a zero from the COUNT.

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

would be for the Department column.

1 would be for the Category column, 2 for the Initiative column, so on and so forth.

Ryan Levitz

Super simple. Love it. Thanks 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.