Percent Complete Issues

I have had multiple users saying that they are unable to fill out the % Complete field correctly without placing the percentage in the form of a decimal. So when they are trying to progress their task to 25%, the value that is returning is 2,500%. In order to get the correct value of 25%, they are having to type in .25 to return the correct value. I have tried to replicate this issue on my computer to no prevail.

When I have tried to remedy the issues at their workstations, I am not able to get it to go through as a standard percentage value either. I have done the following:

- Increased and decreased the decimal location

- Insured the column is formatted as a percentage column

- Recreated the sheet and have had them try other sheets

Very unusual that issue just happens out of the blue when we haven't had this happen with these users in the past.

Anyone's insight or suggestions would really be appreciated!

Thanks,

Alex Palmer

Percent Complete Error.jpg

Find more posts tagged with

Comments

Andrée Starå

Hi Alex,

I've also experienced this, and it seems to be random.

If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team. Smartsheet Support Team

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Alex Palmer

Thanks, Andrée.

I will submit a ticket and post any developments.

-AP

Andrée Starå

Excellent!

Happy to help!

I'll get back to the post if I get any more insight into the issue.

Paul Newcome

I have run into this issue before as well. What has worked for me is to "unformat" the column the reformat it to percentage. Basically click on the column header to select the entire column, click on the percentage button in the top toolbar to turn it back into a number, then click it again to turn it back into a percentage.

Old values still needed to be reentered, but I was able to enter 25 and get 25% instead of 2,500%, and any new values followed the proper formatting.

Alex Palmer

8/15: Partial Fix

Upon reaching out to Smartsheet report, they provided me with the following information:

Log out of all Smartsheet instances (including mobile)
Clear cookies/cache following the steps below for their browser:
- IE steps: Try clearing your browser cache/cookies in IE by clicking the Settings icon then selecting Safety > Delete browsing history. Check the boxes for “Temporary Internet Files”, and “Cookies and website data”. Make sure to un-check the box to “Preserve Favorites website data”. Then press “Delete”.
- Chrome steps: You can clear your browser cache/cookies in Chrome by going to the controls icon and selecting Tools > Clear Browsing Data. In the dialog that appears, select the checkboxes for "All time" and make sure the boxes for “empty the cache” and “delete cookies” are checked.
- Firefox steps: Try clearing your browser cache/cookies by going back to the Firefox Menu > Options > Advanced > Network and in the Cached Web Content section click Clear Now.
- Safari steps: Try clear your browser cache/cookies by going to Safari > Preferences > Privacy, and clicking the “Remove All Website Data” button. Confirm by clicking the “Remove Now” button.
Set the % Complete Column to %. Once they start typing in any cell in that column, the will see % sign appear automatically (screenshots below)

We were able to fix the issue through Chrome following the steps above but were unsuccessful with IE.

We use a combination of IE and Chrome and it just so happens that these users are IE users, so I asked support if they would continue to look into the issue.

I will update the community with any updates.

-AP

Image 1.png

Image 2.png

Sign in to join the conversation!

Trending discussions

Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…
How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto