How to automatically update date when a cell is modified in Google Sheets?

Other Questions Google Sheets
1

Hey everyone,

I’m trying to set up an automatic date update in my Google Sheet, but I’m having trouble making it work. Here’s what I want to do:

  1. Members update numbers in column F
  2. Column G should automatically show the edit date

The problem is, people often forget to change the date manually. I’ve tried a few scripts I found online, but nothing seems to do the trick. I’m not great with coding, so I’m a bit lost.

Does anyone have a simple way to make this happen? Maybe there’s a formula or an easy script I’m missing?

Thanks for any help you can give!

2

I’ve dealt with this exact issue before in my work projects. Here’s what worked for me:

In cell G2 (assuming your data starts in row 2), paste this formula:

=ArrayFormula(IF(F2:F<>“”, IF(F2:F<>INDIRECT(“F2:F”), TODAY(), G2:G), “”))

Then drag it down or double-click the fill handle. This formula checks for changes in column F and updates the date automatically in column G.

It’s been reliable for my team, eliminating the need for manual date entry. The best part is it’s all formula-based, so no scripts required. Just make sure everyone’s using the sheet normally and it should work seamlessly.

Let me know if you run into any issues implementing it.

3

I’ve encountered this challenge in my spreadsheets as well. Here’s a straightforward solution that doesn’t require any complex scripting:

In cell G2, input this formula:

=ARRAYFORMULA(IF(LEN(F2:F), IF(F2:F<>F2:F, TODAY(), G2:G), ))

This formula will automatically update the date in column G whenever a change is made in the corresponding cell in column F. It’s efficient and works across the entire column without needing to be dragged down.

I’ve been using this method in my project management sheets for months now, and it’s been incredibly reliable. It saves time and eliminates human error in date tracking.

Remember to adjust the range if your data doesn’t start in row 2. If you need any clarification on implementing this, feel free to ask.

4

hey amelial, i’ve got a solution for u! try this formula in column G:

=ARRAYFORMULA(IF(F:F<>“”, IF(F:F<>F:F, TODAY(), G:G), “”))

it’ll update the date whenever someone changes a cell in column F. no need for complicated scripts! lmk if u need any help setting it up