Status Update
Comments
ja...@google.com <ja...@google.com> #2
Hello,
Thanks for your report. This issue has been already reported
Cheers!
No update yet.
Hello,
Thanks for your report. This issue has been already reported
Cheers!
Description
I am not able to run script within google sheet, A simple project like this. can nort run due to authorization problem
Do I hafunction onOpen() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var range = sheet.getRange("A:A");
var values = range.getValues();
var day = 24*3600*1000;
var today = parseInt((new Date().setHours(0,0,0,0))/day);
var ssdate;
for (var i=0; i<values.length; i++) {
try {
ssdate = values[i][0].getTime()/day;
}
catch(e) {
}
if (ssdate && Math.floor(ssdate) == today) {
sheet.setActiveRange(range.offset(i,0,1,1));
break;
}
}
}ve to pay to google to run the project within google sheet. Here is the simple script I am trying to run