scripting - How do I add my timer formula back into Google spreadsheet for column of cells? -


we had gotten google developer year or on how add timer field when cell changed, etc.

somehow, deleted or defaulted, lucky enough find equation on 1 of our saved discussion boards. can possibly integrate code

if (sheetname == "driver status" && [4, 9, 14, 19, 24].indexof(column) > -1 && row > 3) 

into our spread sheet again?

you can put out js code executed when sheet edited analyze event object.

here's example googleapps script api documentation

    function onedit(e){   // set comment on edited cell indicate when changed.   var range = e.range;   range.setnote('last modified: ' + new date()); } 

you can check if cell changed or not in if can trigger timer.


Comments

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

python Tkinter Capturing keyboard events save as one single string -

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -