Anyone else have data clearing out of cells?
The issue I've been experiencing for approximately the past 2 weeks is this:
In a sheet or a report, I single-click a cell (to highlight it, not to go into edit mode within it). I leave it highlighted for just a few seconds, and it goes into edit mode on its own, as if I had double-clicked, but it also clears out all the data that was in that cell.
If I notice it immediately, I can use the Esc key to exit the cell and my data will return. Unfortunately I don't always notice (answering someone on Slack, looking at columns further on in the sheet, etc.) and I come back to my sheet with whatever had been in that cell missing, with the sheet having auto-saved after blanking it out.
I'm experiencing it on Edge, Chrome, and Firefox, all with cleared caches.
I did report it to Support on Tuesday, but have not heard back. Anyone else dealing with this or know of a solution or workaround? It's super frustrating.
Here's a screen recording - I click into the ZIV-5 cell, wait a few seconds, watch it blank itself out, then hit the Esc key.
Best Answer
-
@Amy.Mizzi Do you have any other input devices hooked up to or paired with your computer? Or a wireless mouse or keyboard? I've had weird things happen in certain apps when I've had a game controller attached, or when my wireless mouse battery started dying and it was sending ghost clicks...
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!
Answers
-
Under windows,
Windows Update-> View Update History->Uninstall Updates.
Uninstall the latest installed windows update. That should do the trick.
-
@Amy.Mizzi Do you have any other input devices hooked up to or paired with your computer? Or a wireless mouse or keyboard? I've had weird things happen in certain apps when I've had a game controller attached, or when my wireless mouse battery started dying and it was sending ghost clicks...
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!
-
Thanks @Jeff Reisman, it was indeed a dying wireless mouse battery!
-
That's awesome. 😂 A total shot in the dark but it did happen to me once or twice!
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!
-
Hi, I've been having this problem too, and have a wired mouse. I disconnected my wireless keyboard and tested with only the laptop keyboard, and it still happens. Any other ideas?
-
I hope you're well and safe!
Are you using a plugin/app called Amphetamine or similar?
Was that the issue?
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, Awesome, 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.
-
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Unplug the mouse or switch to another wired mouse and see what happens. As the pads below the mouse buttons wear down, there could be unintended and unheard clicks happening. Just a thought, but it happens! My wife works in CAD all day, her mice only last about 2 years before they start going wonky because of the sheer volume of clicks, holds, and drags.
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!
-
Hi, thanks for all the comments, my problem was caused by the Caffeine program.
-
If anyone's got a Caffeine plug-in I can install directly into my brain, that would be awesome!
Glad you figured it out! Good catch, @Andrée Starå !
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!
-
Excellent!
Happy to help!
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. 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.
-
Haha! Thanks! It was the caffeine one I was thinking of, but there's another one called Amphetamine, but that one maybe works as an alternative that doesn't affect Smartsheet in the same way.
I've had a bad experience with one of them where my mac got too hot, and the app overrode it, causing damage to the screen. It was many years ago, so not a risk today.
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.
-
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
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives