Is there a way to weight the average in a sheet summary report?
I have a report that pulls from the sheet summaries of multiple sheets. One of the fields divides two other fields to show the % of items completed. However, when grouping & adding summaries to each column, the % completed summary averages the values below it rather than showing the actual % of items completed. In the screenshot below, I would like the % Items Closed column to display 67% (32 closed items/48 total items), not 59%.
Essentially I'm looking for a way to either calculate based on adjacent summary values or assign some sort of weight to each % value. Last resort would be setting up a metric sheet.
Best Answer
-
Hey @Colin B
Report Summaries can currently only apply a generic AVG to the column selected without taking into account any other values or weighting.
Please submit your feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community. This will allow other users to vote on your enhancement idea!
I agree that a metric sheet with formulas would be the way to go here. 🙂
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
Hey @Colin B
Report Summaries can currently only apply a generic AVG to the column selected without taking into account any other values or weighting.
Please submit your feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community. This will allow other users to vote on your enhancement idea!
I agree that a metric sheet with formulas would be the way to go here. 🙂
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives