Add Timestamps to Google Sheets using the OnEdit() function in Google Apps Script | Aryan Irani

[@gavice79]

Hi Aryan, thanks for the info, I added it to a sheet I have and it works a treat, though I have a page where I am looking for the time stamp to display under the column instead of the row (if someone makes a change in C3:C10 the time stamp would update in C11) I tried to edit the script unsuccessfully if it is possible your help would be much appreciated. thank you, Gavin

[@sachinkale4544]

mail is entered sheet of woner ..shared person is edied email cell show blank....pls guide

[@davidblyth5495]

Thanks for a clear explanation!

[@AryanIrani123]

Glad it was helpful!

[@ewaldot2513]

Sorry want to ask about the email, i try to share my spreadsheet, but the timestamp is okay, but the email did not work to other email that i share can u help me ?

[@AmitJain-r6s]

Hi Aryan, This is realy a amazing code thanks for your sharing this code. Only one issue I am facing in this code that code runs in all the sheets Column A. Its pring date and time in each and every sheet of column A. Please suggest how to fix this.

[@hirak214]

Thanks for the video, loved it!

[@AryanIrani123]

Glad you enjoyed it!

[@ganikhalfan]

Script is working thanks

[@preethirani2394]

Great video 👍

[@AryanIrani123]

Thanks 👍

[@inzakuroku7015]

How if the source data is from sheet mirroring ? Can it identified the data change/ edit as an direct input on the sheet?

[@bpc_ngotuan]

In case there is already data
For example, the data is in column A
I want a formula to get the last input/edit time for each cell in column A

[@vv9730]

I've multiple sheets in a file in google sheet & want to have a sheet which automatically contains date & time on which every other sheets was last edited.
how this can be done..???

[@AryanIrani123]

You can use Version History in Google Sheets or you can use the same code and change the script accordingly to your requirements.

[@MohamadAmirulZakwanBinZahari]

Hello sir is there any way to apply for multiple values in the same col? already tried in my working sheet but only revert the upper values only.. not the whole values .

[@misterhacking8117]

I want to know too.

[@wasimalam3924]

This is good, but it's giving the owner email only, shared editor email is not being populated...
An other issue is that it's not working when the targeted column is protected... Please help in this issue..

[@paulatavares3411]

Hi Aryan Irani
I saw your video about Add Timestamps to Google Sheets using the OnEdit() function in Google Apps Scrip and I tried to apply it doing exactly the same way and with your own example table but the following error appears:
typeerror cannot read property "range" of undefinied google script.
It's my first time using script apps and I'm a very beginner learner.
What am I doing wrong?

[@AryanIrani123]

This means that the script is not able to get the range. Try and change the range or the sheet name or sheet ID.

[@sachinkale4544]

hamare script me code run nahi ho raha hai

[@timevergreen256]

Thankkkkk U

[@AryanIrani123]

Welcome !

[@BusinessBananaShikhe]

How to lock cell atutomaticaly after enter data Google sheet

[@RahulGupta-bn4rj]

Hi Aryan, i want to restrict timestamp generation on values in three columns, kindly give me some tips how can i do that.

[@darrenmoney4130]

You should be able to use greater than or equal to (>=) and less than or equal to (