Yes Kvrka. You can lock the cell just from yourself, or you can have it display a warning when you accidentally try to edit it.

Permissions is the easiest way. In the side panel, click “Set Permissions,” and ensure that your staff has the appropriate editing rights. Then, duplicate the sheet each week. The protected range will remain locked, preventing accidental changes to formulas. This method avoids the need to manually lock the range each time you duplicate the sheet, providing a convenient way to secure specific cells while allowing staff edits in other areas.

Follow the steps above and choose “Show warning” that way you’ll get a pop up window that will let you know you’re about to edit a cell you shouldn’t.

You can use the steps above and choose “show warning” so a pop up message will warn you before you edit the cell.

There’s no simple way to do this. But if you sort the sheet by date it will only take a few moments to select the cells you wish to lock.