Sheet summary - count of Status from multiple source sheets

M_L

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?

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.

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

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.

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

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