Underlying row sort logic

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.
Answers
-
Have you checked the activity log?
-
I have, but maybe I'm not seeing it correctly. Can you tell me how to filter it/what I'm looking for?
-
The Activity Log entry will say "Rows Reordered" whenever the sheet was sorted.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives