Percentage increasing by 100
Hi all,
I have an issue where, when inputting a percentage into the %Complete column which accompanies the Gantt, it multiplies this percentage by 100! I.e. it turns 1 into 100% and 100 into 10,000% - screwing with the sheet.
The strange thing is, this is only happening for one of my team. When i do it, in the exact same cell, 1 = 1 and 100 = 100. The only difference between us is a license but i havent come across this issue before so not sure thats the cause...any ideas? Checked personal settings of the individual etc and they are no different to mine.
Cheers
Jack
Answers
-
Smartsheet calculates percentage as fractions of 1. So .25 = 25%, .75 = 75%, 1 =100%. So really the input method determines what happens. If the column is designated as a % column, and you enter 85 into the column manually, it shows at 85%. However if you're bringing numeric values in from another field they may get multiplied by 100.
So how are you entering data into those cells, and how is your teammate entering data into that field?
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Sat next to each other, manually typing them in but for me it does it one way, for him the other but i do get the fraction bit:
Colleague types '1', cell shows 100%
I type '1': cell shows 1%
In exactly the same cell. So although i take your point, i don't see how it is possibly different other than a glitch?
Thanks for your reply though,
Jack
-
That is strange. Percent seems to function almost like a formatting feature.
@Andrée Starå @Paul Newcome - any ideas?
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
I'm not sure I follow exactly what you are running into?
Percentages are actually a percentage of 1. So 1 = 100%, .5 = 50%, etc etc. Following that logic, 3 would equal 300%. To get 3%, you would need .03.
Does that help explain any?
-
hey thanks for the reply. I agree, but what is happening is 1 turns into 100% for another user but 1 just stays as 1% for me....surely shouldn’t be different?
-
Are you entering into the same field? You mentioned two different fields in your screenshot.
-
Yes I am, that screenshot wasn’t mine sorry, just an example from a community member. Thanks, Jack.
-
@Paul Newcome Screenshot was just something from a test sheet of mine. Trying to see what's going on with percentage fields and help Jack with his issue.
When I enter an integer into a percent field, it shows as a percent. Enter 35, get 35%. When I copy an integer from another column that is not a percent field and paste it into the percent column, it just shows as 35, no percent. Then of course when I change the formatting back to percent, it becomes 3500%.
How can the % format stay sticky? Or do these columns always need to be entered manually or calculated via formula?
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
My apologies. I had that all mixed up. For some reason the thread kept opening to the screenshot as if that was the original post. Ugh. I need some coffee. 😴
When you are manually entering into a % field, it is assumed that you mean 1 instead of 100, but when you pull a number from another field, you are pulling THAT NUMBER in which case 3 would equal 300%.
So if you manually enter 35, it is assumed you mean .35 if you are in a % formatted column, but if the number is coming from elsewhere, then it is assumed you mean that number, so 35 is assumed to be 35 which equals 3500%.
Now... For manual entry into the same cell to provide different results between users (licensed or not)... That is odd for sure. I would suggest reaching out to support and seeing if they are able to shed any light on that side of things.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives