Google-sheets – Sort a range in a shared Google sheet without temporary filter view

google sheets

When I sort a range on a Google sheet, it sorts just fine. When a collaborator who has edit access attempts to perform the exact same action, a Temporary Filter View is produced. When she closes the Temporary Filter View, the sheet returns to its previous state – unsorted.

How can a collaborator with edit access to a Google sheet sort the data on that sheet?

Best Answer

The issue is with protected ranges (in the toolbar under View > Protected Ranges). One of the columns was considered a protected range, and so any sorting was considered a temporary filter. Removing the protected status solved the issue.

Source: Works with OP.