Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.

Can I stop auto delete data in cell

我失去了ce中的数据ll that I choosed it. When I select the cell that has some data for a while, text will disappear. I have to undo to get data back. I am not sure, this is only my problew or another users have it. Please fix this problem as soon as possible cause it is very unconvenience for users and has high risk about accuracy of data.

Comments

  • Hello Rueparade,

    Please contact our Support team to troubleshoot this issue:https://help.smartsheet.com/contact

  • Ok... i've switched to a DELL mouse to remove any concern about hardware. I'll troubleshoot mouse MODE as that appears to be the most viable lead. As of now, I can repeat this behavior with a Dell USB mouse by simply placing it in any cell. releasing my hand. within 5sec, the cell contents is gone. very disturbing. I've not observed this behavior any other place.

    NOTE: please do fix the logitech driver issues... that is not acceptable as a major suppliers of mice and keyboards.

  • Hi Doug,

    The Logitech driver issue is longstanding, and the root of it is specifically the Logitech driver configuration—which we can't change. (Trust me, we'd love to fix this issue but we're unable to fix Logitech mouse/driver behavior.)

    It sounds like you're on track to troubleshoot. You're welcome to contact our Support team if you run into any snags.

  • I opened a case for this as I get the same situation. I use Chrome, not sure that's relevant, if others can pitch in which browser they use... btw the mouse is irrelevant. If you hit F2 on a cell then enter (i.e. not making any changes to it) and wait 5 seconds, the cell below it will auto-delete.

  • I am seeing the same thing. I did report this to Smartsheet and they said it was not Smartsheet. I disagree since this only occurs in Smartsheet, no other application. I tried without my Dell Mouse and even just used my laptop keyboard and same issue. My IT team even remote-desktop'd into my laptop and he saw the same results. I think this really is a Smartsheet issue. I can replicate this about every 50 seconds. I just sit there and watch my screen and poof, the data disappears wherever field the mouse is sitting on.

    My SS Case was closed so...I'm hoping if others report this issue, SS will start to really look into.

  • Shaine Greenwood
    Shaine Greenwood Employee
    edited 04/02/18

    Hi All,

    One other thing to make sure is that the browser or third party applications aren't causing this issue. There are certain browser extensions that can interfere with Smartsheet and we've seen some third party apps (one called Caffeine, for example) that have been known to delete data unexpectedly.

    Turn off all apps and make sure just the browser is running; try a different browser and disable all extensions in your browsers. This will help isolate the issue.

    After trying the above, please alsoreach out to our Support teamfor further troubleshooting. Even if you have already reached out to them and they closed the case, please contact them again and let them know that the issue is still happening.

    If you end up isolating the issue to a browser extension or third party app, reply back in this thread so other community members are informed!

  • Just today I came across the exact same issue as described above and I need some assistance, please.

    I have been using Smartsheets since May of 2017 without this problem. This is the first time this behavior has manifested itself. Some information that may be useful:

    Windows 10 just pushed an update to me on 9/29/2017. First time going into Smartsheet since that happened and I now have this issue with the cell contents being automatically erased after about 3-5 seconds with the cell selected.

    I have used Smartsheet in Chrome browser up until this point. Today is the first time I see the issue.

    Based on te above Forum entry, I tried without a Mouse. Error persisted.

    I tried some Browser changes:

    1) Tried again after disabling all Extensions and starting Chrome again. Error still persists.

    2) Tried Microsoft Edge. Error exists there as well.

    3) Tried Internet Explorer. Error exists there as well.

    4) Tried Mozilla Firefox. Error DOES NOT occur in Firefox.

    The good news is, I have a way to keep working with Smartsheet, which is essential to my job. The bad news is, I do not want to have to use Firefox for one application on my system. I would ask that Smartsheet development team figure out why this does not work and come up with a fix as quickly as possible.

    Thank you.

    Walt Svarczkopf

  • One other addition. I also just ran Smartsheet, using Chrome, with Extensions Enabled. That also DID NOT exhibit the behavior of clearing the cell contents. Hopefully these clues provide some insight into what to do to fix the problem.

    Thank you.

    Walt Svarczkopf

  • I just noticed this happened starting yesterday 10/9/2017. I have been using SmartSheet for years and have not had this issue. This is a pretty debilitating problem. Every cell I select auto-deletes its contents.

    I've tried the workarounds above. I disabled all Extensions in Chrome and I still get the same issue.

    Are more people not having this problem? Have we found a solution?

    Thanks

    Andrew

  • Andrew... Have you tried Firefox as a browser? That is the only solution I have found that works. It's a bit of a pain having to use a different browser for Smartsheet than I use for everything else, but at least I found a way to keep working.

    I see there is an updated to Smartsheet scheduled for the 28th. No idea if this is being fixed or not.

    Can we get an answer from Smartsheet support about this, please? I would think that your customer's ability to use your product, that they are paying for would be a HUGE issue for you to correct. PLEASE RESPOND.

  • It seems like it only happens with Chrome for me, with or without using caffeine.

    Maybe this is something that SS should take a look at and see how to fix.

    Very disturbing to unknowingly lose some data which could go unnoticed for sometime before being realized, which we know will be at the exact wrong time.

  • Hello,

    To troubleshoot this, I'd recommend making sure that you've updated Chrome to the latest version. More info on how to update Chrome is available on this Google support page:https://support.google.com/chrome/answer/95414?co=GENIE.Platform=Desktop&hl=en

    Otherwise, it's likely that a browser extension is causing this issue. Try opening Smartsheet in an incognito window (steps on thathere) to see if the issue still occurs. If it doesn't, then you'll want to disable all of your browser extensions (info on doing thathere) and enabling them one-by-one until you see the issue happen again. Once you determine the extension causing the issue, then you may want to leave it disabled.

  • I am having this same problem. I don't have any third party apps and have tried several browsers. I have now officially sent 3 online requests for help and have not heard back once.

  • same thing here, windows 10 latest version, unpdated browsers, logitech wirwless mouse

    video of the issue here

    https://drive.google.com/open?id=1fjKHLQvTLWlS0cNXDq6h46tBvvBNdtXS

This discussion has been closed.
=[End Date]@row - [Start Date]@row<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":108269,"type":"question","name":"Dashboard Metric Breaks on Update of DataShuttle","excerpt":"I am sure there is something I am missing. But I try to set a Dashboard Matrix on a field that is refreshed by Data Shuttle. But when the Grid refreshes it breaks the Metric and says Data missing even though there is data in the field. Is there anyway around this or does Data Shuttle always break a Metric Cell?","snippet":"I am sure there is something I am missing. But I try to set a Dashboard Matrix on a field that is refreshed by Data Shuttle. But when the Grid refreshes it breaks the Metric and…","categoryID":321,"dateInserted":"2023-07-28T17:52:38+00:00","dateUpdated":null,"dateLastComment":"2023-07-28T22:21:10+00:00","insertUserID":164293,"insertUser":{"userID":164293,"name":"Joshua Jones","title":"IT Specialist","url":"https:\/\/community.smartsheet.com\/profile\/Joshua%20Jones","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T22:18:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":164293,"lastUser":{"userID":164293,"name":"Joshua Jones","title":"IT Specialist","url":"https:\/\/community.smartsheet.com\/profile\/Joshua%20Jones","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T22:18:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":31,"score":null,"hot":3381150828,"url":"https:\/\/community.smartsheet.com\/discussion\/108269\/dashboard-metric-breaks-on-update-of-datashuttle","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108269\/dashboard-metric-breaks-on-update-of-datashuttle","format":"Rich","tagIDs":[292,474],"lastPost":{"discussionID":108269,"commentID":387933,"name":"Re: Dashboard Metric Breaks on Update of DataShuttle","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387933#Comment_387933","dateInserted":"2023-07-28T22:21:10+00:00","insertUserID":164293,"insertUser":{"userID":164293,"name":"Joshua Jones","title":"IT Specialist","url":"https:\/\/community.smartsheet.com\/profile\/Joshua%20Jones","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T22:18:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-28T22:21:14+00:00","dateAnswered":"2023-07-28T20:45:34+00:00","acceptedAnswers":[{"commentID":387914,"body":"

How exactly is your Data Shuttle set up? If it is set to replace everything in the sheet when it runs, it is deleting the cell being referenced by the widget and then putting new data in new cells.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]},{"discussionID":108271,"type":"question","name":"Conditional formula - if a date is less than 30 days from today","excerpt":"I'm trying to create a conditional formula to flag if less than 30 days from today. I create a separate column to calculate but I am getting an error on the formula. =IF(AND([Event Date] > TODAY(), [Event Date] <= TODAY() + 30), \"Less than 30 days from today\", \"More than 30 days from today\") Help?","snippet":"I'm trying to create a conditional formula to flag if less than 30 days from today. I create a separate column to calculate but I am getting an error on the formula.…","categoryID":322,"dateInserted":"2023-07-28T18:21:58+00:00","dateUpdated":null,"dateLastComment":"2023-07-28T19:22:21+00:00","insertUserID":159884,"insertUser":{"userID":159884,"name":"Connie Cochran","url":"https:\/\/community.smartsheet.com\/profile\/Connie%20Cochran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T19:21:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":159884,"lastUser":{"userID":159884,"name":"Connie Cochran","url":"https:\/\/community.smartsheet.com\/profile\/Connie%20Cochran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T19:21:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":25,"score":null,"hot":3381143059,"url":"https:\/\/community.smartsheet.com\/discussion\/108271\/conditional-formula-if-a-date-is-less-than-30-days-from-today","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108271\/conditional-formula-if-a-date-is-less-than-30-days-from-today","format":"Rich","lastPost":{"discussionID":108271,"commentID":387894,"name":"Re: Conditional formula - if a date is less than 30 days from today","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387894#Comment_387894","dateInserted":"2023-07-28T19:22:21+00:00","insertUserID":159884,"insertUser":{"userID":159884,"name":"Connie Cochran","url":"https:\/\/community.smartsheet.com\/profile\/Connie%20Cochran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T19:21:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-28T19:21:56+00:00","dateAnswered":"2023-07-28T18:55:42+00:00","acceptedAnswers":[{"commentID":387890,"body":"

Try this:<\/p>

=IF(ISDATE([Event Date]@row), IF(AND([Event Date]@row > TODAY(), [Event Date]@row <= TODAY(30)), \"Less than 30 days from today\", \"More than 30 days from today\"), \"\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts