Sum values from a report

Hello, I have a log sheet that records a project name, resource and hours, with many rows of entries. I would simply like to create a report that sums all hours by project. I don't see how this works in the report function, but it seems like it should be doable.

Any help would be appreciated.

Nick

Find more posts tagged with

Reports

Comments

Tony Coleman

Hi Nick, don't believe you can perform calculations from within the report. However the standard work around I would use, is a Rollup Sheet - linking the total hours (top level) of each project into one high level sheet - you can indent those linked metrics so they rollup to a summary value as well. Does that help?

Cheers

Marcus Odum

I agree with Tony. What I have incorporated a SS practice for my projects is to add the stats at the top or bottom of the sheet. When create a master sheet for all metrics across my portfolio.

If you have sights you can get really fancy. I use these dashboard with my leadership team, and they really like the view.

https://www.smartsheet.com/sight-gallery