Posts

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())