How to create a sheet summary/ column of functions to summarize the data within the summary sheet?

Hi,

I have a workspace with several sheets of data (broken out by year) that I created sheet summaries within each tracking the same metrics using the same functions. I then created a summary sheet of my sheets and added the metrics columns I am tracking in each. I am able to create dynamic widgets on the dashboard, but it breaks them apart by sheet (year). Is there a way to summarize my data in my summary sheet using functions so I can create a dynamic widget that represents the metrics we're tracking for the entirety of data (not broken out by year)? We have decades worth and when we tried to put all of our data on one sheet, we reached the cell limit.

Thank you for your help and please let me know if an image or clarification would be helpful! ☺️

Find more posts tagged with

Accepted answers

All comments

Jgorsich

There almost certainly is, but you'd really need to include some kind of screenshot for reference.

Without screenshots, it may be worth noting that your breakout by year in the widget is coming from the data you are supplying - add one more layer of abstraction (formulas that sum up the various yearly totals) and tie your widget to that and you are likely going to be fine.

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.