-
Spreedsheet+Site.Google
Hi Team,
Kindly help me in below spreedsheet and site.google
Am having a spreedsheet, in that i have kept a search in sheet1-cell(B2) to search a values from sheet2, and i have kept a reset button to clear the values in Sheet1-B2.
Spreedsheet is embedded in site.google.
Issue: Reset button is not working in site.google, below is the link
https://sites.google.com/view/author...iptsearch/home
https://docs.google.com/spreadsheets...DsQ/edit#gid=0.
Note: Reset button is working in spreedsheet, but not working after embedding into site.google
Kindly resolve
-
-
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