Write a formula that checks whether or not the cell is in a parent row, then performs the following

Write a formula that checks whether or not the cell is in a parent row, then performs the following calculation based on this information:

If a task has children, sum the children.

If a task has no children, subtract [Extra Column] from [Status].

Write the formula in the [Numbers] parent row, then drag the formula down to apply it to all the children rows.

Calculation Based on Hierarchy Position.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try something like this:

=IF(COUNT(CHILDREN()) = 0, Status@row - [Extra Column]@row, SUM(CHILDREN()))

You should be able to convert this into a column formula instead of having to dragfill.

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.