Sign in to join the conversation:
I have the entire column formatted as a percent, but when I enter 100, it shows as 10,000%, or when I enter 1 it shows 100%. Would like for the number entered to show that percent.
Hi Randy,
You probably need to change the decimals (see attached screenshot)
Did it work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
No that did not work. Moving decimal to the left does nothing and moving it to the right just changes it to 10,000.00%
SS recognizes percentages as a fraction of 1. So 1 = 100%, 0.5 = 50%, 0.25 = 25%, so on and so forth. If you have the column formatted as percentage, you will need to enter the decimal equivalent.
Seems to be a bug. There was a delay when I tested but now it works as intended!
It happens when the values are already in the cells when you apply the percentage format. If I set the percentage format and then add the values, it doesn't happen.
Andrée
No my issue is actually when a new value is typed in. I was using Internet Explorer, just tested in Chrome and it does not persist.
It was a little strange here also so maybe it was a short glitch. I'll try later again.
I tried it again in both Chrome and Safari and it's working as it should.
How did it go for you?
People in my company have been having this same issue. I noticed that it was happening for some people but not for others. I don't know how to fix it as I think there might be a glitch that needs to be fixed with the software, but I have been able to replicate it.
We have a "% Complete" column. This is a text/number column that has had "%" formatting applied to it. If you type in any number, the "%" symbol pops up. If you hit enter, that number will stay with the symbol staying with it. If you input "100" and then hit delete to remove the percentage symbol and hit enter, it will change to 10,000%. I've confirmed with one colleague that this happens to her, but not with the ones who notified me of the issue to begin with. I will update when I hear more.
Similar problem - see snapshot. Even tried copying the same cells to a blank section of the same sheet - didn't help. All the other "roll-ups" on the same sheet display as % - as it's supposed to. Something is glitchen' here....
Michael
Have you tried clicking on that specific cell and formatting as percentage?
Smartsheet acknowledged that this is a known bug in Internet Explorer. Switch to Chrome corrected the issue. or you can type the decimal equivalent (i.e. .5 for 50%)
Thanks for sharing Randy!
We've encountered this issue as well... found that if we highlight the contents of the cell to edit the value and do not include the '%' sign is when the value gets reformatted to be x1,000 the original value. If you just enter the new value directly into the cell vs. first clicking in to highlight the value the x1,000 does not happen.
Hi, Is there a way that I can set up a Notification Automation that goes to the email/requestor is their email is the Primary Column? Currently I have the Primary column as "Created By", and the requestors input their email address. But, if I try to set up a Notification automation using the Template or even from Scratch.…
I accidentally deleted our Purchase Order (P.O.) open form in Smartsheet and would like to ask for assistance in recovering or restoring it if possible.
Hi all - just thought I would float this here first to see if anyone has had similar experience (and any fixes), before sending a ticket through to support. Have a basic automation notification set up with a company logo and task bar color in place. All has been working great but today it won't include the company logo or…
