I want to protect my sheet in order to enable only some users to edit it. I also have a filter function in this sheet with which users can filter data by people's names. When I tried protecting my sheet (even partially), the filter function is not working. What can I do to enable filter at the same time with protecting it?
1 Answers
When creating a filter with Google Apps Script, all ranges referenced by the filter must be editable for the current user.
The solution is to apply the filter using formula instead of GAS, this way it doesn't matter if the ranges are protected, as users are just reading the values, not editing them.
Related