Skip to content

Instantly share code, notes, and snippets.

@tsaiid
Created August 17, 2017 13:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tsaiid/2b300fdb88ca22824db6c03f29b5e70c to your computer and use it in GitHub Desktop.
Save tsaiid/2b300fdb88ca22824db6c03f29b5e70c to your computer and use it in GitHub Desktop.
Go To The Row of Current Date After The Google Spreadsheet Loaded
/* modified from https://webapps.stackexchange.com/a/78996/129361 by user79865 */
function onOpen() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var range = sheet.getRange("A3: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;
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment