i have been looking for a way to timestamp my google sheet,
its working if i edit the cell and it work great exactly how i want it, however.
im not the on editing the sheet, its through a 3rd party application that just dumps data into the sheet in the background.
all i want to be able to do is open the sheet after awhile and see when the 3rd party did what etc.
im using createOnchangetrigger which is calling a function to input date into r.offset(0.6) which works fine. but like i say only when i actively go in and change something, not 3rd party :..)
ideally i dont want to look at this sheet, only when someone makes a mistake on 3rd party this collates all the 3rd applications in one place.