We use a sheet as both a schedule and data collection tool as part of a much larger system we just put in place (literally 5 days ago, moved from google sheets). The information is organized manually first by employee and second by the priority of projects. Recently, the information in the sheet began jumping randomly throughout the document. No matter where rows are placed they somehow seem to end up somewhere else on the document. It is wasting both the time of the directors, who have to manually go back and reorganize all of the information every time they open the sheet as well as the employees who have not been able to prioritize their workload because the information never stays put.
There are no filters being used, most people on this sheet only have view only access, and since it's hand sorted anyone who DOES have editing capability knows not to use the sort function. Simply changing a few cells or moving a couple rows up/down seems to mess the entire thing up sometimes.
I know for a fact it's not user error, because I have made sure to go into the sheet when noone else was on to see if the problem still occurs. Ohhhh boi. Yup.
After months of having to work with a program that is in need of some serious updating (the amount of workarounds and duct tape/superglue fixes to stupidly simple pitfalls), this is seriously the icing on the cake. I mean honestly, the one thing you would expect a spreadsheet to do is stay in the order you last left it.
I need to know why this is happening. I don't need another goofy solution/workaround. Just why. won't. my. sheet. stay. in. order.
-reports are not an option as I need to be able to quickly edit/add rows/move rows/delete rows.
-I will not consider adding a sorting column because a) That is an extra step which will still get missed when the other 20+ people finally have editing capability and the issue will remain and b) there is already a concern that we might reach the max cell/column limit too early. (which btw is ridiculous considering this isn't exactly a free tool)
We're becoming increasingly frustrated, losing time and money, and every day becoming more and more doubtful that moving to this was a good option.
