I'm trying to filter a protected column in a spreadsheet that I shared with other users.
But I it looks like I can protect it or filter it with the other user but not both.
In Excel I can do it without a problem. Do I have any option to do so?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
At this time, on Google Sheets
The above behaviour is by-design. If you want that it be changed, submit a feature request through the Help menu > Report a problem
An alternative is to add an auxiliary sheet to include the data from the protected range by using an array like the following:
This way the original data is kept secure while allowing users without permission to edit the protected range with edit access to filter views on the auxiliary sheet created by others.
If a column of a spreadsheet is protected from a user (i.e., that user does not have edit rights to the column), then the user cannot use Filter command from the menu. The command will even be greyed out when the cursor is in that column; it won't be greyed out elsewhere but an attempt to filter will still be blocked if it would affect a protected range.
The reason is that applying a filter is considered editing: the appearance of the spreadsheet is changed for everyone.
Solution: the users who are unable to apply a filter to the document should use a filter view, as described in Filters vs. filter views.