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!