Home > Net >  Spreadsheet jump to current date issue
Spreadsheet jump to current date issue

Time:02-23

Hello dear community,

I am unfortunately not able to figure out where's the issue in @Serge insas AppScript to jump to Today's cell in my own spreadsheet.

Fixed potential issue with different timezones date format, however, the script jumps to the last cell as: sh.getRange(5,sh.getLastColumn()).activate(); indicates, but not to Today's cell.

Important to mention that my Spreadsheet is constructed horizontal, enter image description here

Note: I used Snoopi sheet in the example above, I added 5 in the 2nd parameter of getRange() because the start of the count is in the 5th column or January 1. Also, when using multiple Sheets, make sure to use ss.getSheetByName(name) this is to prevent script from applying the code to different sheets which might happen if you use getActiveSheet()

References:

  • Related