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!
Comments
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).
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.
Please sign in to leave a comment.