Decimals keep changing
I have a dropdown column that we used for style numbers. They might be numerical values or alpha/numeric values. The column has always show the value that was selected in the dropdown as it should until the last week or so decimals are being added. No matter how many times I remove the decimals from the column when new entries come in via the form the decimals keep getting added. This row is locked and the column properties has the box checked to only allow dropdown values. Does anyone have any idea what is causing this and how to correct it. This is causes extreme issues with our reporting as it is changing our style numbers and this data is going out to vendors. We need help asap.
Best Answers
-
Hi again,
Thank you for this other thread! I've contacted our Support team with the details in both of these Community threads and they have identified this as a bug; the team is working on this right now but I don't have an ETA for when it will be resolved.
Thank you,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
I'm always happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Have you tried Decrease Decimal?
-
Using the decrease decimals only changes the data that is already in the sheet. When new data is entered via the form, the data come in with decimals again. The form uses a dropdown and the "restrict data to dropdown only" is checked, yet Smartsheet is still changing the entry to contain decimals.
-
I hope you're well and safe!
I've seen multiple similar posts, so it seems that there is a known issue at the moment.
@Genevieve P. I've checked the Status page, but nothing is listed, but it seems to be multiple users that are having issues.
If you haven't already, I recommend reaching out to the Smartsheet Support Team.
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I submitted a ticket but the suggestion was to log out and to check my browser etc. These things will not work since all of my users are experiencing this issue, not just me.
-
Thanks for the tag, @Andrée Starå!
I personally haven't experienced this or seen any reports of a known issue.
@Crystal Perry if you're working with Support already, please keep following up with them, detailing the troubleshooting steps you've tried and providing them with any screen captures / videos that they're requesting. This will be the best way to troubleshoot as you can share more detail privately in a 1:1 channel, and if you continue to respond to the same ticket/email then it will provide more context so Support can identify if other customers experiencing the same thing due to the same root cause.
Thanks,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi again,
Thank you for this other thread! I've contacted our Support team with the details in both of these Community threads and they have identified this as a bug; the team is working on this right now but I don't have an ETA for when it will be resolved.
Thank you,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
I'm always happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives