Totals from report or sheet summary for dashboard

Sarah Hole

Hi

I have been able to create a sheet summary report and standard report from my sheets - aprox 10 sheets.

I want to put a single $ from all the sheet totals into one figure on the dashboard. I can only get the reports to provide individual sheet totals.

How do I sum a Grand total from a report?

Thanks

Stefan

Hi @Sarah Hole ,

you don't, sorry.

That's the typical use case for a so called "summary sheet", where you have one row for every project and the columns you need. In such a sheet you can easily sum the individual project values. A report from the summary sheet provides the data for the dashboard.

Hope this helps

Stefan

Stefan

Hi @Sarah Hole ,

you don't, sorry.

That's the typical use case for a so called "summary sheet", where you have one row for every project and the columns you need. In such a sheet you can easily sum the individual project values. A report from the summary sheet provides the data for the dashboard.

Hope this helps

Stefan