Rounding in Formula

I would like to round the result of this formula.

=(ROUND(SUM([KR1 Calc]7, [KR2 Calc]7, [KR3 Calc]7, [KR4 Calc]7, [KR5 Calc]7)) / 3 + "%")

KR1 Calc]7 = 0

[KR2 Calc]7 = 100

[KR3 Calc]7 = 100

[KR4 Calc]7 = 0

[KR5 Calc]7 = 0

Currently returning = 66.66667%

I would like to round this to = 67%

Find more posts tagged with

Formulas

Hi Steve,

Have you tried removing the +"%" part and formatting the cell(s) with Percentage Format instead?

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

You could also try including the "divided by 3" portion in the ROUND statement.

=ROUND(SUM([KR1 Calc]7, [KR2 Calc]7, [KR3 Calc]7, [KR4 Calc]7, [KR5 Calc]7) / 3) + "%"

Thank you both for your help. Solution successfully implemented.

Happy to help!

Excellent!

Happy to help!

How to split contents from a cell from a smartsheet into another smartsheet
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.
How can I set up recurring tasks in Smartsheet?
I need tasks that repeat (daily, weekly, monthly, yearly). Each should show a due date and a “Completed” checkbox. When I check it off, I’d like the task to log in an archive sheet with the completed date and then reset on the main sheet with a new due date and cleared checkbox. Has anyone found a simple way to do this?
Information in a form populates specific cell.
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…