Why is % complete showing as 10,000% instead of 100?


I have a basic project sheet and the % complete is showing as 10,000% instead of 100%

I have several other sheets where this is working correctly (ie I enter 100 and it stays as 100%, but in this one sheet when I put in 100, it defaults to 10,000%.

I understand the basic math for how this equates but don't understand why SS is operating differently in this sheet? I've seen old posts about a bug in Internet Explorer, but this appears to e operating this way in Edge and Chrome.

Any ideas?

Thank you!


  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    edited 11/11/22

    Hi @Kelly Pratt,

    Seems there are 2 known ways for this to happen.

    1.) Enter the number for the % Complete, but click delete before tabbing or clicking enter. This removes the % sign, and adds 2 trailing zeros when you do tab or click enter.

    2.) Enter the number into a cell, and then apply the % format to the cell/column.

    Seems as if it's not browser specific.

    If these are not causing your issue, then you need to have a call with Smartsheet Support.

    All the best,