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 is married to his favorite person, and loves his three children quite a little bit (aged 10, 15 and 17). 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.