I am entering data into a Google Sheet. I would like to have a column where each row will be automatically timestamped with the
DateTime in which I entered (or last updated) the contents of the row.
I know that I can do this manually by adding
=now() to a cell, which will record the timestamp. However, this will update on any change to the doc, so I then need to copy and
ctrl-shift-v to paste back just the value.
Would be more ideal if there was a formula that I could paste down the column which would only set
now() as the value if there is a change in any of the selected columns in the given row.
Thoughts on how to do this?