I find the "protect range" function in Google Spreadsheets very useful, but I have one problem: I often need to set all of the collaborators' permissions to, for example, "Can comment."
It is very tedious to set them manually all at once, so is there any way to set all of the permissions to "Can comment"?
Or, is there any way to change the default permissions for a protected range?