Rounding Summary Numbers in Reports
We have reports that show us turnaround times for certain items. We are using the summarize feature to take an average for those turnaround times, but the decimals do not come out cleanly or consistently. Is there a way to round these averages so that it is a whole number?
Best Answer
-
@AshleyDeichmueller glad you got it partially working! also just FYI you would need every source sheet to be formatted the same, just confirming you have done that as well.
Answers
-
@AshleyDeichmueller If you go to the source sheet(s) and format that column as a number with the decimals you want it to show, then it should update on the report to match that. Do it to the whole column. let me know if that works
-
@Samuel Mueller I have tried increasing the decimal, saving, then decreasing back down to no decimal points and it still does not round the average in the report. Is there anything else I can try?
-
@AshleyDeichmueller I'm sorry I don't know any other options, and it works in my example. try formatting the column to have one decimal and then save your sheet. And then go to your report refresh it and see if that works.
Do you have multiple source sheets?
-
@Samuel Mueller Yes there are multiple source sheets. I tried doing it with two decimals and it worked for consistency! I don't think the whole numbers worked, but the 2 decimals should be fine. Thanks for your help!!
-
@AshleyDeichmueller glad you got it partially working! also just FYI you would need every source sheet to be formatted the same, just confirming you have done that as well.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives