Introducing LASTEDIT(), a Timestamp Formula for Google Sheets

“When was the last time this sheet was uploaded?”

Probably one of the biggest requests I get is how do I add a timestamp to check when some particular range was changed. While most of the time you can get away with adding the NOW() formula or even checking version history, how can you automate this to always check if, for example, A5:B5 was last updated?

Well, below is a simple function you can add to your Google Sheets doc to add the formula LASTEDIT(). Simply copy and paste this code to your Script Editor under Tools and use it as you would any other formula.

Image for post
Image for post

After that just type what Range you want to check if there was an update and where you want to place the timestamp.

Image for post
Image for post
Image for post
Image for post

Well, I hope you found this useful!

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store