Script - Today's Date
function onOpen(){ SpreadsheetApp.getUi() .createMenu("Scripts") .addItem("Make Copy With Todays Date", "makeCopy") .addToUi(); }; function makeCopy() { var formattedDate = Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd"); var ss = SpreadsheetApp.getActiveSpreadsheet(); var ss_id = ss.getId(); DriveApp.getFileById(ss_id) .makeCopy(formattedDate.toString())
Comments
Post a Comment