Sorting a protected range in Google spreadsheets

Question

I've been trying to make the spreadsheet automatically sort some data, and after some searching I found this post: Automatic sorting.

It works just perfect with my permissions as the owner, but when any of my collaborators edit a cell he gets the message You don't have permission for this action.

I found that the problem was that some of the cells in the range to be sorted are "protected" and only I can edit those cells.

So my question is: Is there any way to automatically sort the data and keep the cells protected?

Answer 1

I am fighting with the same problem, I think it is because the protected cells are set statically and not affected by the sort. The reason is that Google Spreadsheets do not allow the selection of multiple ranges with are not adjacent to each other.

In other words, If you have a defined protected range in the Spreadsheet, it will always be the same rows and columns, regardless of your actions (adding rows and columns, sorting them and so on).

This is a huge drawback of the Google Spreadsheets.