Tag Info

Hot answers tagged


The closest program I can think of to accomplish that would be the FireFox extension BYTubeD. With it, you can browse to the playlist, and just run it, and it will collect all the videos neatly like this: http://cl.ly/KYO2 (Don't ask, I just found a random playlist). Then you can copy and format as you wish.


Try this instead. Code function onOpen() { var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets(); for(var i = 0, iLen = sheets.length; i < iLen; i++) { var sheet = sheets[i], range = sheet.getDataRange(); range.sort({column: 1, ascending: true}); } } If you want to sort from a certain row or column, then use this code ...


This duplicates data (or since the source for the query is itself imported, even triplicates) but does seem to provide automatic resorting as data input changes: =query(A1:B5,"Select * order by B desc")

Only top voted, non community-wiki answers of a minimum length are eligible