I have found a similar question here:
How to make Google Sheet jump to today's column when opened?
I want to do a similar thing, but I have the dates in row 5 not in the column. I tried several times to make it work by doing some changes, either in the first than in the second script, but it didn't work. I'm really new, so I suppose the solution is easy, but unfortunately, I am not able to solve it by myself.
The code in the question I quoted is this:
function 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;
}
}
}
Please, can someone help me?
Best Answer
var range = sheet.getRange("5:5")
= dates in row 5var range = sheet.getRange("E:E")
= dates in column 5