I have a spreadsheet in which users fill in their names for their shifts for next month, and they should do it only during 20th to 25th in a month but they keep breaking this rule. So I would like to lock the spreadsheet on all other days but that is kind of annoying doing it manually. So I would like to ask if someone knows how to write a script that would keep the spreadsheet unlocked for editing from 20th to 25th in each month but lock it for the rest of the month.

Anyone who knows the solution for my problem?

  • It's not an answer, but I recall something about google-apps-scripts running on a time interval. Maybe, using something along that line. It's not an answer also cause I've saw it a long time ago and I'm not sure where to start from. ;-) – Oneide Dec 15 '18 at 23:51

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.