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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 216 Industry Talk
 456 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!