Sum of child rows multiplied by other row.

Hello Community,

Can the sum of child rows that are individually multiplied be achieved without the use of a helper column?

I would like to be able to detail the total sum of the child rows [March 2025] multiplied by [Rate] without the use of a helper column. I =SUM(CHILDREN([March 2025]@row ) * CHILDREN(Rate@row )) without success.

My preference for not wanting to go the helper option is I currently have >80 columns where I would like to apply this calculaiton.

Grateful for any ideas,

Protonsponge

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Not natively. You could do it with the API, the premium add-on Bridge, or some other similar third party app, but within the core product you are stuck with the helper column.

Here is a link to a product idea that you can add your vote to regarding getting a SUMPRODUCT function:

https://community.smartsheet.com/discussion/107181/please-add-a-sum-product-formula

All comments

Paul Newcome

Not natively. You could do it with the API, the premium add-on Bridge, or some other similar third party app, but within the core product you are stuck with the helper column.

Here is a link to a product idea that you can add your vote to regarding getting a SUMPRODUCT function:

https://community.smartsheet.com/discussion/107181/please-add-a-sum-product-formula

Protonsponge

Thank you very much @Paul Newcome, I was bracing myself for an embarrassingly obvious answer to be shared. Appreciate the knowledge sharing and will now get to work making helper columns.

Protonsponge

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.