Forum Discussion
Automatically adding the date/time to a cell when another cell is updated
I am trying to create a spreadsheet where when a specific cell is updated in anyway, the date/time stamp automatically updates in the cell right beneath the cell that was updated. I only need to have...
I have a similar problem. I'm trying to update one cell in a row (column G) if any other cell in that same row is modified (columns range from A to R). So for example, in row 3, if cells A3:R3 are modified (number or text or dropdown menu change), then cell G3 updates to that day's date only (no timestamp). Any help is appreciated!
Try this formula "=IF(A1-O1="","",NOW())"
I placed it in Cell P1 of the document I have it in. So when I make any changes in Cells A1 through O1, Cell P1 will change with the date and time the change was made.
I'm not sure how well it will work if you place it in a middle cell of the formula. I hope this helps.