Rounding percentages in sheet summary
I am looking for a way to use the percentage number format on sheet summary and to be able to round the percentage to a whole number.
I have tried adding ROUND to my formula but this just populates the field with 0 as the calculation to convert the number to a percentage happens separately to this.
These fields link to a dashboard where i need to see the figures as a percentage.
Example below where I would like 29.64% to be 29% and when i use the ROUND function i get 0.00%
Any help appreciated! thanks
Answers
-
Hello @VicR. I believe your solution is using the ROUND function, specifying in the second parameter the number of decimals to consider (that would be 2 in your case). Regards!
-
@Nicolás Trejo thanks for this - i have tried with the 2 and it rounds but still has the 2 decimal places in the percentage - is there a way to just get this to display as 30% rather than 30.00%?
Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!