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.

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

Well, I hope you found this useful!