'Specified time, move the first (date format)sheet to the last place in tabs
How to make it possible to run the script every night at 23:00, the sheet name's based on that day's date, e.g. today's date (2022.02.11)
the sheet: 2022.02.11 move it to the last place in the tabs?
as an example I would like to achieve this with script
since, it should work on android and other platforms, i think its not an option to have a sidebar or maybe a macro..
I found one like this, but it just does what you do when you click on an active sheet moves it to left
function tab() {
var reportDate = new Date();
var tabName = Utilities.formatDate(reportDate, "GMT+", 'yyyy.MM.dd').toString();
var tab = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(tabName);
SpreadsheetApp.setActiveSheet(tab);
SpreadsheetApp.getActiveSpreadsheet().moveActiveSheet(1);
}
it was mentioned familiar here, and this script above is also from there, I just changed the date format to mine Move Sheet Tab to the Far Left Using Script
Thanks in advance for your help!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|


