Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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?
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
