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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!