Automatic sum of all children and grandchildren


I have a budget sheet that needs to automatically sum the cumulative totals of all levels of children including new grandchildren as they are added, but the =sum(children()) formula does not include grandchildren rows.

Is there a formula able to be contained within a single cell to do this?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!