Going to sheet based on date

Question

I have a sheet for every day. Example: 3 january 2022 > sheet name is 3/01/2022

When I open the google spreadsheet file, I want the active sheet is the sheet of the actual date. So when opening the spreadsheet on 5 january 2022, the active sheet 5/1/2022 should be in front of me.

How do I do that?

Thanks for helping

https://webapps.stackexchange.com/questions/145827/how-to-open-a-specific-tab-based-on-todays-date-google-sheets — player0, Dec 09 '21 at 20:06
https://stackoverflow.com/questions/60496802/open-to-todays-date-within-multiple-tabs-in-a-sheet — player0, Dec 09 '21 at 20:06
https://stackoverflow.com/questions/16213555/google-apps-spreadsheet-open-specific-sheet-based-on-current-date-month — player0, Dec 09 '21 at 20:07

score 0 · Answer 1 · answered Dec 09 '21 at 21:03

Get Sheet by Date

function onOpen() {
  gotoPage();
}

function gotoPage() {
  const ss = SpreadsheetApp.getActive();
  const name = Utilities.formatDate(new Date(),ss.getSpreadsheetTimeZone(),"MM/dd/yyyy");
  const sh = ss.getSheetByName(name);
  sh.activate();
}

It's kind of slow getting there but it works for me.

Going to sheet based on date

1 Answers1

Get Sheet by Date