How Do I add Sum(Children) at the bottom of the children rows

User251

Hi,

How do I use the =Sum(Children) function in Smartsheet to sum child rows and display the total at the bottom.

I usually create a parent row, then add rows beneath it, indent them and add the formula =Sum(Children) to the parent row to calculate the total. However, that structure was confusing for users, and they preferred seeing the title at the bottom rather than the top. How can I do that?

AravindGP

Hi @User251

Unfortunately, you can't. Unless the whole calculation is manual where you are having a formula like =SUM([Column1]1:[Column1]20) where 1 and 20 represents the row numbers and Column1 represents the name of the column in which you've the values to sum/

AravindGP

Hi @User251

Unfortunately, you can't. Unless the whole calculation is manual where you are having a formula like =SUM([Column1]1:[Column1]20) where 1 and 20 represents the row numbers and Column1 represents the name of the column in which you've the values to sum/

User251

@AravindGP Thank you!