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!
Answers
-
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,
-Ray
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives