I need a formula that will place time and date of an entry on each row separately and not change the previous entry's time and day.
I use an ID number in column A as a reference.
=IF(A5>1;NOW();0) it works but the next row entry changes all previous entries to the current time and date.
I use an ID number in column A as a reference.
=IF(A5>1;NOW();0) it works but the next row entry changes all previous entries to the current time and date.