Glitch Moves and Deletes Rows and Columns

Has anyone else experienced groups of rows and/or cells moving in their Smartsheets? It seems to happen overnight with 10-20 rows moving from the top of my Smartsheet to the bottom. This morning two columns were found deleted and Smartsheet doesn't have a revert function so I'll have to rebuild them. This has happened more than 8 times over recent months, maybe once ever two or three weeks.

Find more posts tagged with

Education

Marketing

Community Platform

Comments

Shaine Greenwood

Hello,

This is likely being caused by either a person saving from an old copy of the sheet, or by an integration or other automation service that interacts with that sheet.

If you're on a Business plan or higher, you can check the activity log on the sheet and see what email address is moving the rows and deleting the columns. Click the Activity Log tab at the bottom of the sheet to view; more info on activity log is available in our help center: https://help.smartsheet.com/articles/2476206-track-sheet-changes-with-activity-log

Otherwise, if you don't have a business plan—contact our Support team. They may be able to narrow down the email address responsible for the deletion.

Catch22

I have also experienced Rows being inserted in the Middle of the Smartsheet and the sort on a column changing. Eventually found rows way down the sheet - not sure what happened. Really need some sort of versioning - not just a Backup. Alot of work can be completed and lost in 24 hour period between backups

I looked at activity Log and there was nothing there

heybubb

Shaine,

I know this thread is old, but believe your response may be the reason behind what we're experiencing here.

Is there a simple way to prevent this? We have multiple people using the same sheet, and they are refreshing and saving, but it seems rows continue to get moved. Sometime a row will move 200 rows down and there is no way a previous version of the sheet had the rows in that place.

Any help would be great

Andrée Starå

Hi,

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

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet Access report
Hello. Me and my team are doing an audit of users who have access to edit items in our account and one of the reports we're using is the Sheet Access report under the User Management section of the Admin Center. However, we're running into some weird things. When we dig into the Sheet Access report, we sometimes notice…
Does sheet access require new users to create a smartsheet account?
No License required I am sharing a published link, no license required to a group of people. The goal is for them to be able to edit the sheet. Would each member be required to create a smartsheet account? Please, is there a way for them to access my sheet without having to create an account? Many thanks!
Backspace, enter and delete keys not working...
This has happened a couple of times before. However, when trying to update a form or even a field in the smartsheet, I am unable to use the backspace, enter or delete key. I use Google browser, however I wasn't sure if it was Google, so I switched to Microsoft Edge. Still not working. Also, I tried using the backspace,…