How to make checkboxes auto-uncheck daily on two different tabs on the same sheet, with different ranges for the different tabs (script help?)
Hi! I was able to get this script to work for one of the tabs in my work's google sheets, but I cannot figure out how to get it to be able to auto-trigger and uncheck checkboxes on two different specific tabs, with two different specific ranges.
function timedresetboxes() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('B6:B29').uncheck();
}
Currently, I am using this^ through the Google Apps Script and it runs and correctly unchecks the boxes on the tab I need.
However, I guess it does not specify the tab name in the sheet I am using it for. I am not versed at all in coding, and found the above script to use from a different reddit thread.
I need to uncheck boxes at midnight daily on the following tabs with the following ranges:
tab name: アマ
range: B6:B29
tab name: DAILY TASK 🌴
ranges: F5:F20 and K5:K:20
I trust reddit people to know what to do, it is probably an easy fix for someone who knows what they are doing! Thank you!