-
Thanks for the reply and new solution.
Can you share a code to reset to zero '0' for cell B2 automatically after 5 minus.
below code is not working for me
function myFunction() {
var sheet = SpreadsheetApp.getActive().getSheetByName('sheet1'); sheet.getRange('B2').setValue(0);
}
function createTimeDrivenTriggers() {
ScriptApp.newTrigger('myFunction')
.timeBased()
.everyMinutes(5) //I can not write 0.01 instead of 1 here.
.create();
}
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules