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 120 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
Recommended Answer Recommended Answers (2)
Recommended Answer
Most Relevant Answer
Hi,
Try the below script:
​​function onEdit(e) { var ss = SpreadsheetApp.getActiveSheet(); var r = ss.getActiveCell(); //1.Change 'Sheet1' to be matching your sheet name if (r.getColumn() < 9 && ss.getName()=='Sheet1') { // 2. If Edit is done in any column before Column (I) And sheet name is Sheet1 then:var celladdress ='I'+ r.getRowIndex() ss.getRange(celladdress).setValue(new Date()).setNumberFormat("MM/dd/yyyy hh:mm"); }}; recommended this
marked this as an answer
Recommended based on info available
Our automated system analyzes replies to choose the one that's most likely to answer the question. If it seems to be helpful, we may eventually mark it as a Recommended Answer.
Most relevant based on info available
Our automated system analyzes the replies to choose the one that's most likely to answer the question.
Recommended Answer
Most Relevant Answer
Hi,
Just make sure from the time zone selected for the sheet - Goto: File > Spreadsheet setting > Timezone
recommended this
marked this as an answer
Recommended based on info available
Our automated system analyzes replies to choose the one that's most likely to answer the question. If it seems to be helpful, we may eventually mark it as a Recommended Answer.
Most relevant based on info available
Our automated system analyzes the replies to choose the one that's most likely to answer the question.
Most Relevant Answer Most Relevant Answers (0)
All Replies (60)
Recommended Answer
Most Relevant Answer
Hi,
Try the below script:
​​function onEdit(e) { var ss = SpreadsheetApp.getActiveSheet(); var r = ss.getActiveCell(); //1.Change 'Sheet1' to be matching your sheet name if (r.getColumn() < 9 && ss.getName()=='Sheet1') { // 2. If Edit is done in any column before Column (I) And sheet name is Sheet1 then:var celladdress ='I'+ r.getRowIndex() ss.getRange(celladdress).setValue(new Date()).setNumberFormat("MM/dd/yyyy hh:mm"); }}; recommended this
marked this as an answer
Recommended based on info available
Our automated system analyzes replies to choose the one that's most likely to answer the question. If it seems to be helpful, we may eventually mark it as a Recommended Answer.
Most relevant based on info available
Our automated system analyzes the replies to choose the one that's most likely to answer the question.
Recommended Answer
Most Relevant Answer
Hi Abbas,
Thank you so much!
Not all heroes wear capes.
You saved the day!
recommended this
marked this as an answer
Recommended based on info available
Our automated system analyzes replies to choose the one that's most likely to answer the question. If it seems to be helpful, we may eventually mark it as a Recommended Answer.
Most relevant based on info available
Our automated system analyzes the replies to choose the one that's most likely to answer the question.
Recommended Answer
Most Relevant Answer
you're welcomed!
recommended this
marked this as an answer
Recommended based on info available
Our automated system analyzes replies to choose the one that's most likely to answer the question. If it seems to be helpful, we may eventually mark it as a Recommended Answer.
Most relevant based on info available
Our automated system analyzes the replies to choose the one that's most likely to answer the question.
Recommended Answer
Most Relevant Answer
Hi again Abbas,
While that did work perfectly, I just realised it's not in my timezone.
I live in the "GMT" timezone, but it seems to be giving me GMT-4.
Is there anyway I can rectify this issue?
Thanks again!
recommended this
marked this as an answer
Recommended based on info available
Our automated system analyzes replies to choose the one that's most likely to answer the question. If it seems to be helpful, we may eventually mark it as a Recommended Answer.
Most relevant based on info available
Our automated system analyzes the replies to choose the one that's most likely to answer the question.
Recommended Answer
Most Relevant Answer
How to I do the same Timestamp script, but it would only occur if a cell value changes, rather than a manual update?
recommended this
marked this as an answer
Recommended based on info available
Our automated system analyzes replies to choose the one that's most likely to answer the question. If it seems to be helpful, we may eventually mark it as a Recommended Answer.
Most relevant based on info available
Our automated system analyzes the replies to choose the one that's most likely to answer the question.
This question is locked and replying has been disabled.
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.
This reply is no longer available.
Badges
Some community members might have badges that indicate their identity or level of participation in a community.
