In the past, when two people were editing the same Google sheet, if person A attempted to do a sort they would get a "heads-up" warning that A's sort was going to affect person B.

We now don't seem to get that heads-up message anymore, but we frequently have cases where if person A sorts while person B is editing a cell, the edits go into the wrong cell ... i.e., they go into the physical row and column that B was initially editing, but because of the sort, this is no longer the correct destination for the edits.


2 Answers 2


Use filter views to sort the sheet instead of using Data > Sort. This feature lets multiple simultaneous users sort, filter and edit the sheet without disturbing each other.

For additional ease of use, you can insert links in the frozen section of the sheet to easily switch between filter views, instead of having to go to Data > Filter views to switch. See the Filter views example spreadsheet for an illustration.


Filter views only mask filter criteria from other users; sorting within a filter view will also affect the unfiltered view for others. ( based on my own trial and error in attempts to isolate sort changes affecting other users )

P.S. lack rep points to add as comment instead of answer; sorry in advance.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.