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

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?

Find more posts tagged with

Formulas

parent row

Accepted answers

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/

All comments

AravindGP

Hi @User251

User251

@AravindGP Thank you!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.