Could we make the calculation to a "Report" file?

Chris Wang

Hey guys, now I have a question asking for your help:

Now there are many project schedule in my workspace, so I use the "report" function to filter some key info and data that I want to summarize and show to the the management team.

Could we just make a calculation to a "report" file then create a dashboard from it? Or if there is a more convenient way? (Now I need to create a new sheet then copy the filter result then do the calculation job)

Andrée Starå

Hi @Chris Wang

I hope you're well and safe!

Have you explored using the Grouping / Summary functions in Reports?

https://help.smartsheet.com/articles/2482083-summarize-content-to-extract-key-information-with-report-builder

https://help.smartsheet.com/articles/2482082-configure-grouping-to-organize-results-in-report-builder

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!