Underlying row sort logic

Sarah P

Can you help me understand the underlying logic of how the rows are sorted and why it changes? My understanding was that the rows were supposed to stay sorted once we saved the sheet until someone else changes it, but that's not the case. I'll be messing around in the sheet in the middle of the night when no one else is touching it, and it still changes frequently. I see there are years of complaints about this issue without a satisfying fix beyond the workaround of using reports. But if I don't see where anybody has really explained why it happens.

Paul Newcome

Have you checked the activity log?

Sarah P

I have, but maybe I'm not seeing it correctly. Can you tell me how to filter it/what I'm looking for?

Paul Newcome

The Activity Log entry will say "Rows Reordered" whenever the sheet was sorted.