Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    How to Step Rounding Percentage

    ✭✭✭✭
    edited 07/24/24 in Formulas and Functions

    Below is a very basic formula actual/workset a to get the %achieved.

    You can see that the two calculations are off one should be 33%, the other 20%

    What is the best way to show the actual value, not the rounded value?

    Thanks!

    image.png
    Tags:
    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Best Answer

    • ✭✭✭✭
      Answer ✓

      Ah! I figured it out. It was essentially a double-rounding error.

      The formula in Workset A column was 22*0.25, now it's =rounddown(22*0.25)

      Then when I apply the formula to the %Achieved column (actual/workset A) it's now accurate. Now I know I need to be more conscious about formulas when there are shared components.

      Thanks pointing me in the right direction.

      image.png
      · Share on FacebookShare on Twitter

    Answers

    • Community Champion

      In your sheet toolbar, look for the highlighted icon below.

      image.png

      Leroy Noriega | Smartsheet SME | Independent Smartsheet Consultant

      Core App, Project Management and System Administrator Certified🏅

      E: leroy.noriega@yahoo.com | Linkedin Profile

      · Share on FacebookShare on Twitter
    • ✭✭✭✭

      Thanks — I already tried that — it only adds decimal places. It doesn't correct the formula result.

      This is the simple formula I'm using: =IFERROR(Actual@row / [%Achieved]4, "--")

      · Share on FacebookShare on Twitter
    • ✭✭✭✭✭
      edited 07/25/24

      Im assuming that the formula =IFERROR(Actual@row / [%Achieved]4, "--") is in column Workset A, and you want to correct %Achieved column.

      What is your formula for the %Achieved column to show that it is 36% and 21%?

      If formula for %Achieved is what you are looking for, I think should be =IFERROR(Actual@row / [Workset A]@row, "--")

      ...

      · Share on FacebookShare on Twitter
    • ✭✭✭✭
      Answer ✓

      Ah! I figured it out. It was essentially a double-rounding error.

      The formula in Workset A column was 22*0.25, now it's =rounddown(22*0.25)

      Then when I apply the formula to the %Achieved column (actual/workset A) it's now accurate. Now I know I need to be more conscious about formulas when there are shared components.

      Thanks pointing me in the right direction.

      image.png
      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions