Another strange behaviour - forms!

Hi Smartsheet,

I have no time to search correct helpdesk email address, so I put this here.

I have a form used by 10 employees with field which is set up as % value. Everything was ok, but from few minutes everytime they enter value like 50, it appears in the sheet as 5000%. WHY?

Why that two zeros are added to the value??? Doesn,t matter if the form is entered from mobile or PC.

I am getting more an more dissapointed and being person who implemented the whole Smartsheet from scratch in my company, I am getting worse and worse feedback...

It's so sad...

EDIT: I found some time and went to the helpdesk. This is how it looks:

Find more posts tagged with

Forms

Comments

Paul Newcome

It is because you have it formatted as a percentage type column. Smartsheet reads percentages as a decimal. 1 = 100%. 0.5 (one half) = 50%. Etc.

Marcin P

I could agree with you, but until today it was working as it should, so when I entered 50, form entered 50%. So why it changed just like that?

Paul Newcome

Could the column have been changed at any point? That was the only way I could duplicate your issue. When I set the column as percent, it showed a small % in the field of the form as I was entering it. When I changed the format of the column is when it changed how it was displayed. Are ALL of the numbers entered through the form?

Marcin P

Hi Paul,

Not at all. I am an admin, so if there would be any change, I'd know it ;] and there would not be a point to post anything here. Column is still formatted as %.

I tried to enter value as 0,5 and it landed as you said, as 50%, but anyway day before yesterday it was working absolutely fine.

Regarding % mark in the form, another yes - it's there.

Marcin P

Hello again,

I've made it! I was wondering what will happen if I'd create another duplicated column with the same settings.

So far so good!

It behaves as it should. So we have a situation now like I have two columns set up in an identical way and one gets 50 as 5000% and the other as normal 50%.

Don't know what to say...

EDIT (again): NOPE! I posted few forms and everything was ok. As soon as one of our guys in field posted new form, everything went back to problem... What a nonsense...

Support stays quiet.

Marcin P

Just received an email from support saying that they replcated this issue and they are working on it on higher level of techs.

Just to let you know.

Paul Newcome

Hmm... Thanks for the update. Hopefully they get it squared away soon for you.

Susan Peck

We also see this behavior on sheets occasionally. Generally, if you enter the value again (say 50 or 99), the extra zeroes go away. Since the behavior is random, it's hard to replicate.

Glad to hear this bug is being investigated.

susan

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…