Make a Self Checking Checklist
Learn how to create a self-checking checklist in Google Sheets using App Script, allowing your checkboxes to be automatically checked at set intervals.
Could this be the laziest checklist ever ? Normally, I have to check the checkbox here. But what if I could set up a timer that checks off this checklist by itself? Let's look at . Appscript, we've written this Appscript that gets the active spreadsheet , gets sheet one, gets the values that are in B2 to B9, and then it checks for every single checkbox . Is it checked? If it is not checked, that's what this exclamation point does here. If it's not checked, it's going to check it. And then break for every time we run this. How can we run this by itself? Go over to triggers. And we add a trigger . Select the function check. Choose time driven. Choose, hour timer. And every hour, click save. And now this trigger. We'll check this box every hour. We can also delete it over here. Delete trigger. Laziest Checklist Ever Automate Google Sheets without Apps Script, without Zapier Laziest Checklist Ever Automatically Reset Your Daily Checklist