How to Make a Recurring Weekly Checklist

0:00 Let's make a recurring weekly checklist . So we have a checklist , we're going to create a task, we're going to check off tasks, and we want these things to uncheck every single week. So let's do that. We're going to have to create a function , create a trigger , and then I think we're going to be done. Let's go up to extensions, Apps Script . We're going to create a function called uncheck. And uncheck is simply going to go to the spreadsheet , get the active spreadsheet , which is the entire worksheet file, get sheet. By name. In this case, it's going to be sheet one. We're going to get a range. And that range we can hard code into B3, B13. Then we're going to do dot uncheck. Now, if we save it and we run uncheck, we can see that they're unchecked. Everything is unchecked. Now we want to run uncheck every single week. So go over to the left side, go to triggers. And on the bottom right, there will be a button called add trigger.

0:45 Click that. We're going to choose which function to run. If you have any other functions written here, you'll have to find uncheck and click it. The event source, we're going to choose time driven. Select type of time based trigger . We're going to choose week timer. And then we get to select the day of the week. We'll probably want to do it every Friday. And then at the time, we'll probably do it at the end of the night. So do something like eight to nine p. m. So that's the end of our week. It'll be unchecked ready for the beginning of our week. And I'll click save. Now we have a trigger that is time based. It's running the function uncheck. If we want to edit it, we need to come back to triggers and click on the pencil icon to edit it. If we want to delete it, click on the three dots. to the right and click delete trigger and that's it. Now we've made a recurring weekly checklist.