We have been using SmartSheets in our workshops for around 5 months now as a schedule but there is one issue we have not been able to figure out why it is doing it.
The smartsheets I am referring to are schedules with parent rows as our "Job" and the children as steps within that job.
We have an automatic locking on the parent row which means that only our planners have the ability to move the parent rows around or use the sorting function (of which they do not touch as it was causing more issues then help).
The planners will manually sort the jobs into order or date and priority for the workshop personnel so that they can view the plan in that order.
I have seen this happen and it has happened to me 20+ times where the rows seem to move by themselves into a new order.
The 2 people that had access to move the rows (myself and the planner) sat together on several occasions on one computer and moved the order of the jobs around. When we pressed saved smartsheet did it's saving process, then once it was saved we scrolled down and everything was out of order again (and yes we are sure we pressed save and not refresh - this has happened on many occasions over the last 5 months).
Secondly, there has been times where we have pressed save and then refresh and the order is saved into the new order. During these times only myself and the planner have access to move the order of the sheet and neither of us have been at our desks. We come back, refresh and it is all out of order again.
At first, I was sure that someone must be accidently reordering or something, but now I have witnessed the same thing time and time again.
I have a theory it has something to do with if another user (even without the ability to move the rows around) has the sheet open on their computer in the original order... then after the order is changed and saved that user does not refresh. They they update a percentage or something without refreshing and one their version of the smartsheet auto saves it saves the old order overtop of the new order as that person did not refresh.
So while they do not have the ability to "reorder" if the old order was still showing on their screen could this then override the new order the planner as saved as they didn't refresh?
Does SmartSheet look for any new saves in the order before overriding this with a save someone else has done if they have not yet refreshed.
I have seen this issue come up quite a few times now with other people in this community and we personally are losing a lot of time resorting our plans.
If this is the issue (not refreshing and the old order saving over top of the new sorted sheet) is there something in the roadmap to combat this... or something we can do to reduce the amount it happens. Is it a case of turning off all the auto saves and training people to refresh before they walk away from their desk?
Any insight would be great as this is a continual issue we are having.
thanks so much
Sammy
p.s. we have raised a ticket and are waiting a response.
2 screen shots attached - first one with 2 childrens expanded. Second with them all collapsed and a few out of order yet again 

