Automate Row reference in Sheet Summary Field

Hello,

I have a sheet that regularly updates with new rows. I use the "Sheet Summary" tool to summarize columns of data that are then shown in reports. Whenever a new row is created in this sheet (by a form), the sheet summary field does not update to include that row in the summary.

Is it possible to have the sheet summary formula include ALL rows, or update the row reference as new rows are created?

Find more posts tagged with

Accepted answers

SJ Sellers

Can you share the formula you are using in your Sheet Summary? That will help troubleshoot your issue.

My guess is that you are using a range (Amount1:Amount14) rather than a column (Amount:Amount) reference, but that's just a guess without other information.

All comments

SJ Sellers

Can you share the formula you are using in your Sheet Summary? That will help troubleshoot your issue.

My guess is that you are using a range (Amount1:Amount14) rather than a column (Amount:Amount) reference, but that's just a guess without other information.

Bennett R.

Hi SJ,

I am using quite a few, but here is a countifs formula that should show what what i'm doing for most.

I use similar formulae for sumifs for the same data sets.

=COUNTIFS([Sub-SBU]1:[Sub-SBU]36, "Hardlines", [Project Type]1:[Project Type]36, "Productivity")

I'll try =COUNTIFS([Sub-SBU]:[Sub-SBU], "Hardlines", [Project Type]:[Project Type], "Productivity")

and see how the goes.

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.