Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Reports in SmartSheet
I want to create a report that summarizes information on my smartsheet. I don't want it to list individual line items. Is this possible? I am trying to mimic something I am doing in Excel with pivot tables and tables. If it's not possible - does anyone have recommendations for reporting plug ins?
Comments
-
If you add the subtotals and totals you could set a report for those summarizations. If you add Sights into your subscription this is a really helpful executive dashboard to summarize any data you like..
-
You may consider using hierarchy in the sheet to create the summary calculations. Once you have indented a set of rows, you can add a formula like =SUM(CHILDREN()) or =COUNT(CHILDREN()) in the parent row to summarize them.
You can then create a report that only pulls in the parent rows. To make it easy to select a particular hierarchy level in your report, you can add a column to your sheet where you fill down the formula =COUNT(ANCESTORS()). This will calculate the hierarchy level of each row.
If you have Sights, you can then add one or more summary reports to the Sight, or pull particular summary cells from a sheet into the Sight to create a dashboard.
Hope this helps!
Daniel
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives