Cell values automatically reverting to previous values. Changes won't save.

I have a very serious concern.

I am updating the contacts column to change the contact from Richard to Teresa. However, after about 10-15 minutes Smartsheet automatically reverts to the original contact. This has been happening for a week . I am very concerned because how can I be assured that changes are saved in all my Sheets? I just so happen to have an automation to notify me of any/all changes to this Sheet.

That contacts column is not linked to any other Sheet. There isn't the small arrow to the bottom right of the cell that lets you know which Sheet(s) a cell is linked to. Is it possible for a cell to be linked without this indicator? Just in case, I disabled Resource Management. I reached out to Smartsheet Support and they do not have a solution. They actually suggested that it could be a conditional formatting issue, which let me know they did not understand when I clearly stated that it is the value of the cell that keeps automatically reverting. I do not have an automation that affects that contact column. I check the cell history and whenever the value reverts to the original contact, it shows that I am the one making the change. Which is insane, because I am not undoing my own updates.

Has anyone experienced this? What else could the problem be?

Thanks.

Find more posts tagged with

Sheets

Contacts

Support

Cell linking

Accepted answers

All comments

NickStaffordPM

Are the changes you are making and saving showing up in the activity log right away as they should? Or when you save, are those changes not shown in the activity log?

I am trying to to determine if the change is being acknowlegded by their servers at all or if it is jusr dispearing before it gets to them.

SJTA

@NickStaffordPM

Yes. The changes show up in the Activity Log.

NickStaffordPM

It may help your case with Smartsheet IT to screenshot the activity log right after you make a change and then after it disappears again so you have evidence. That may help explain tot hem the issue so they can address it properly.. because something wrong it definitely happening lol

Vivien Chong

My first thought it could it be an automation set up to assign task to Richard? But since you mentioned there is no automation associated with that contact column… I have not encountered this, but I am curious to find out why this is happening… 😁

PSExcellence

I have the same issue happening with formulas. I will update a "reference" in a formula to point to another sheet/column, and later I go back and it has reverted to the old reference. Not only that, but when I try to fix it, it won't let me use the new reference name I chose because it claims it's "already being used on the sheet" (even though it is not…because it has reverted to the old reference and no other formumla is using the new one).

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.