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

Evonn Scotlen

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.

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.