How to actually USE the summary info from a report?
I have two reports both bringing in information from the same sheet. One is grouped first by country, then by month. The other is grouped just by month. For each of these groupings, I have it summarizing totals and maximums for each column. This is brilliant, this is exactly the information that I need. But now I need to be able to do things with this information and I'm not sure how?
The primary thing I'd like to do is create line graphs showing the trends over time, using the information that's in the summary lines of the report, but that data seems almost inaccessible. Is anyone able to take this information and use it, either on a dashboard as visuals or have all of this copied to another sheet to use it further, or is seeing the summary line data the end of the road?
Report 1:
Report 2:
Carly Chaput, PMP (she/her)
Project Manager | Program Management
www.linkedin.com/in/carly-chaput
Answers
-
hi @Carly Chaput,
Once you have report built on Sheet Summary you can create a Dashboard on Chart Widget based on it.
So the data will be visible as a chart, graph etc. it's very simple.
Hope it helps
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives