I have a Google sheet with contact information that is accessed by many people. These people need to have the ability to sort information and edit it.

Some users, when sorting, accidentally only sort information in one column, instead of sorting the entire sheet by that column. This results in mismatched contact information.

How can I make it so that users are still able to sort, but when they do, they only have the option of sorting the entire sheet?

  • can you share a copy of your sheet? (if not due to sensitive intel, pls create dummy sheet with fake data and link it here)
    – user0
    May 14 '19 at 0:05

Add the users as viewers, not as editors, this way they will be able to use filter views to filter and sort the data but the filtering/sorting the do will not bother other users and will not change your spreadsheet.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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