I love it when someone else figures these kinds of things out and then shares them.
function sortSheets () { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheetNameArray = []; var sheets = ss.getSheets(); for (var i = 0; i < sheets.length; i++) { sheetNameArray.push(sheets[i].getName()); } sheetNameArray.sort(); for( var j = 0; j < sheets.length; j++ ) { ss.setActiveSheet(ss.getSheetByName(sheetNameArray[j])); ss.moveActiveSheet(j + 1); }}
He owns a typewriter and collects Laserdiscs. He loves his three children quite a bit (aged 11, 16 and 18). He is passionate about authentic learning, technology with purpose, and creating at least one new thing every day. In short, he teaches, and learns. A lot.