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?