This content is likely not relevant anymore. Try searching or browse recent questions.
Automatic Timestamp when a Cell on the same row gets Updated. 2 Recommended Answers 60 Replies 130 Upvotes
Hi,
So I'm trying to make a spreadsheet with multiple rows and columns (obviously).
Each row belongs to a customer, and each column contains a piece of data for them.
I want to add a column on the very end of the spreadsheet so that whenever a customer's row is updated in any cell along the row, the cell in the very end column will bring up a date and time stamp of when the row was last updated.
I've been googling this issue for days, and I know that I'll have to use a script, but what script do I use?
Could somebody help me out please?
I've attached a link to a sample spreadsheet that you can play around with and figure out the script.
Thanks in advance for your help!
Details
Link to post
Delete post?
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.