How to update this formula so it automatically updates?

by Chris   Last Updated December 06, 2018 13:03 PM

First time on here, it's come to my attention that GoogleClock no longer works on new sheets, anyway I can update the below code so it can update every minute.

Tried put =SheetNames(NOW()) it says not allowed. I'm very new to scripts (below script I found on here)

Help appreciated :)

function SheetNames() { // Usage as custom function: =SheetNames( GoogleClock() ) try { var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets() var out = new Array( sheets.length+1 ) ; //out[0] = [ "Name" , "gid" ]; for (var i = 3 ; i < sheets.length+1 ; i++ ) out[i-7] = [sheets[i-1].getName()]; return out } catch( err ) { return "#ERROR!"

SheetNames.flush(); } }



Related Questions


save data in new column every day

Updated November 08, 2018 05:03 AM

Avoiding an authorization request for google scripts

Updated November 23, 2018 16:03 PM

Which is better: onEdit or onChange trigger?

Updated August 14, 2018 16:03 PM