"Refresh" sheet issue

neelesh

Need help..

The sheet that i am working upon gets updated by the Form.

I updated one cell entry manually and saved the sheet.

Though when i refresh the sheet - the entry of the cell i manually entered changed to his previous value.

Any specific reason - why refresh is changing the cell values?

Find more posts tagged with

Forms

Comments

neelesh

Just to add.. i tried locking the row, still its value in cell changes when i refresh.

Debbie Sawyer

Are you able to right click on the cell and View History. Are all the changes actually being recorded?

colleen.green80641

We have the same issue when more than one user is updating a sheet. We do see improvement when we use the refresh link (top of sheet to the right of sheet name) and then select save... this seems to save the current users data plus the changes that were made by someone else are not wiped out.

Shaine Greenwood

Hello—

It's possible that someone else is making changes and saving from an older version of the sheet.

It's important for everyone working on a sheet to refresh before they make changes to make sure they're not overriding your changes.

Check the cell history of the sheet to see who might be doing this. More info on cell history is available in our help center: https://help.smartsheet.com/articles/518314-viewing-cell-history

Mike Wilday

I think this issue can be explained by this thread: https://community.smartsheet.com/discussion/report-not-updating-0 There is currently some issues with Reporting in Smartsheets.

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…