How to protect the whole column every day in order using the app script. For Example: On day 1: Protect col A, On day 2: Protect col B... etc
Asked
Active
Viewed 59 times
0
-
for protecting a range see https://stackoverflow.com/questions/38993561 - for getting the day out of a date see Date's method getDay() - and for getting an entire column by the number, use a combination of getRange and getMaxRows – Ricardo Aranguren Apr 10 '22 at 17:00
-
Please show what you have tried and add a brief description of your search efforts as is suggested in [ask]. – Rubén Apr 10 '22 at 19:33
-
What happens when it reaches the last column? It goes back to A? Consider explaining what you tried, including whatever code you're currently working on. – Iamblichus Apr 11 '22 at 11:21