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!

5

Comments

1 comment
  • 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).

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post