What Formula Would Handle This?


I want the top row to calculate everything below it. I was using the Sum Children formula, but once I made the indent below with "Flavored Kre Pre-Launch", it won't calculate anything below it (just only if I put something in that same row). So, is there a way to write the formula in the top cell to read all of the ones listed below? I know a simple SUM formula listing the row ranges would do it, but I want to be able to simply add new rows down below without having to update the top row formula each time. The SUM Children one does this, but not with anything indented below.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!