The idea is pretty simple, have a cell log date and time like
NOW() when a cell in the same row or a specific cell is changed, But i didn’t find a solution without using Apps Scripts.
Ideally I’d like to use one formula to cover the whole Column, This is the best I came up with, it dones’t work as intended so I didn’t "beautify" it
You may try something alike this:
Enable iterative calculationin sheets setting as in screenshot
- Format the
Column Bto timestamp format