Protected ranges on the template sheet

I am attaching a Google Sheets template to a Form where in this Sheets template I have set some permission like:

- Sheet1 only People from group A have access to edit it.
- Sheet2 only Person from group B have access to edit it.

Problem is that when a new document is created, the  template copied do not keep those permission and permissions are missed during the copy therefore previous protected ranges do not work anymore.

System should keep protected ranges!



  • Same issue for us. This is quite a problem, as we have some complex rules for protected ranges. Having to set this for each and every instance of the document created from template will be very time consuming (and defeats the purpose of the template).

    Comment actions Permalink
  • We have the same issue, We have few sheets that are protected to Admins in the template. However when the document is created the attachment looses all the permissions from the template and sheets are still protected. Only the Document Creator can access the protected sheet, We have ask every Document Creator to manually share the permissions of protected sheets with the Administrators.

    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post