Interval Update Function on Google Script Spreadsheets

When writing a Google Script for Spreadsheets on Google Docs, I found out that the Functions does not update itself even already set a built-in timer.

So, a way to work around is to set one cell such as A1 = Minute(Now())

Then for cell B2 can set =TimeNow(B1) , so TimeNow will get triggered every minutes.

Advertisements