How can I create a helper sheet that reads totals from multiple reports

Alan Miller 11

I need to create a 'helper sheet' sort of like a metrics that will collect multiple counts from multiple reports so that I can chart it easier in my dashboard. I currently have 60 reports which each have 3 counts on them, meaning that each one would need to be charted individually. I would like to be able to create a 'helper sheet that has a live copy of these figures all in one location so that I can create a stacked bar graph that shows the same data in one large graph. I know with sheet to sheet you can do cell-linking, or some community posts have suggested the index/match but I am finding that all of these only look at sheets and not report. I have tried pulling all the data I need to into 1 report but it will not allow me to group the data as needed. (Too much information).

Are there any helpful tips for accomplishing this?

Paul Newcome

You will need to leverage the API or the premium add-on Bridge to accomplish this.

Alan Miller 11

Thank you!

Paul Newcome

Happy to help. 👍️