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.
Answers

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.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!