I have a similar formula (not mine);

=IF(C8="yes", IF(E8="",NOW(),E8),"") this does create an accurate timestamp in the current cell. My problem is when I use this same formula but in a different row, =IF(C10="yes", IF(E10="",NOW(),E10),""), it creates new timestamp but also changes the original timestamp to match. I can't seem to make the original timestamp permanent. Any ideas would be appreciated.