Why sheet requires saving when nothing changed?

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Why sheet requires saving when nothing changed?

This happens on 2 of my 10 sheets, and only started happening a few weeks ago. The moment I mouse over the grid of my sheet, the disk save icon immediately goes blue (enabled), thus indicating that something changed on the sheet. Thus when I now click on another sheet, a dialog window prompts me to confirm to save my sheet, don't save, or cancel. It indicates changes have been made to the information in Smartsheet.

I can't find any sheet configuration or personal settings that would cause this odd behavior. I am certain it isn't my auto-save feature under personal settings, because this issue always happen on the same two sheets. It is an inconvenience having to deal with the dialog.

My activity log confirms that the sheet was viewed, but not editing changes occurred. So why does Smartsheet think that the sheet changed the moment I hover over the grid?

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Win,

    Are you using the TODAY function or a formula that checks when the something was last modified or similar?

    I hope that helps!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    I had this happen to me today as well. Cross sheet formulas didn't update until I opened the sheet and then I was able to save.


    There is no TODAY function used on that sheet either.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Paul Newcome &@Win LeDinh

    For one of my clients, it seems like it was the Modified column and formula we used to get the last modified date.

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Thank you everyone for your tips! I had both the Created By and the Modified By columns, and after removing them, the problem went away.

  • So for one of my sheets, removing the Last Created By and Last Modified By columns fixed my issue. However, for my other sheet, I need both columns since I have other formula columns that references the Last Created By column, or a automation workflow that references the Last Modified By column, thus I cannot delete those two columns.

    I still don't know what recently changed that could have caused this problem. A few weeks ago this issue didn't exist. I did save a copy of my original sheet, then deleted rows from the original sheet that I no longer needed. I didn't create any new formulas, and even if I did, there is no reason for Smartsheet to think that the sheet changed when no editing changes are made to the sheet. Very odd behavior.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Win LeDinh

    Ok. Yes, that's odd.

    If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team.

    Let us know what you find out!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • I just submitted a ticket to the support team to inquire. I shall post their response/resolution in the near future.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Win LeDinh, Excellent!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.