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!

Find more posts tagged with

Accepted answers

All comments

Ray Lindstrom

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.