The summary of ‘Google Sheets: Copy With Protections’

This summary of the video was created by an AI. It might contain some inaccuracies.

00:00:0000:05:19

In this video, the presenter addresses the challenge of maintaining protected ranges when copying a spreadsheet template, a scenario often encountered in environments like restaurants where employees need restricted access to certain parts of the sheet. To resolve this, they introduce a "copy with permissions" script that preserves these protections. The script works by identifying the active spreadsheet, setting the template sheet, retrieving existing protections, and utilizing the `copyTo` function to duplicate the template along with its protections intact. They further demonstrate creating a loop to iterate through an array of protections, applying them accurately to the new sheet while ensuring no editors are retained and domain edits are set to false. This solution enables efficient and accurate duplication of protected sheets within the same spreadsheet.

00:00:00

In this part of the video, the presenter discusses how to handle protected ranges in a spreadsheet, specifically when copying a template. They illustrate a common problem in a restaurant scenario where employees need to input specific information without being able to edit other parts of the sheet. Normally, one could use a protected range, but copying the sheet typically loses these protections.

To solve this issue, they introduce a script called “copy with permissions” that retains the protected ranges when duplicating the template. The script involves getting the active spreadsheet, setting a variable for the template, retrieving the protections, and creating a new sheet by copying the template. They also demonstrate using the `copyTo` function to duplicate the sheet within the same spreadsheet and rename it numerically for easy tracking.

00:03:00

In this part of the video, the speaker explains how to create a loop that iterates through an array of protections in a template sheet and applies them to a new sheet. The process involves retrieving the range of each protection using A1 notation to avoid errors, removing all editors, and setting domain edits to false. The speaker demonstrates running the script, which copies the sheet, applies the same protections, and verifies that the protections are active on the new sheet.

Scroll to Top