Sheet summary - count of Status from multiple source sheets

Hello,

I have 7 source sheets that I would like to use for a sheet summary report. Only one of the sheets is returning values to the report.

All the sheets have the same 'Status' column, with the same values in the dropdown.

Question is: why is only one sheet returning values?

Find more posts tagged with

Reports

Sheet Summary

Accepted answers

Genevieve P.

Hi @mlanterman

I would double check that the titles in all of your Sheet Summary sections are the exact same.

Screen Shot 2020-11-12 at 6.46.37 PM.png

For example, each sheet should have a section in the Sheet Summary that says "Total Closed RAID Items", letter for letter like this.

If your other 6 sheets have different titles for the totals (for example. "Total Closed" or "Closed RAID Items"), then these totals will appear under a different column that you will need to select in the Report Builder. Does that make sense?

You can learn more about Summary Reports in our Help Center, here.

Cheers!

Genevieve

All comments

Genevieve P.

Hi @mlanterman

I would double check that the titles in all of your Sheet Summary sections are the exact same.

For example, each sheet should have a section in the Sheet Summary that says "Total Closed RAID Items", letter for letter like this.

You can learn more about Summary Reports in our Help Center, here.

Cheers!

Genevieve

M_L

Hi Genevieve,

That makes complete sense, and my summary report is working now!

Thank you very much and have a nice weekend,

Matt

Genevieve P.

Great, I'm glad that worked for you!

Cheers,

Genevieve

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.