Jul 15 2020 05:39 PM - edited Jul 15 2020 05:40 PM
Jul 15 2020 06:13 PM
There's a function called NOW() which will get the current date and time.
The issue is that it updates every time the worksheet is recalculated.
To use that function but keep the time shown static as you add new rows, you can use iterative calculation to allow a circular reference to keep the value in the cell if it's already there.
Go to File>Options>Formulas and enable iterative calculation:
Now, in A2, you can put this formula:
=IF(B2<>"",IF(A2<>"",A2,NOW()),"")
You'll see that this formula is checking if there's a value in B2. If there is, it's checking if there's already a value in A2 (where the formula is). If there is already a value, it leaves it alone. If there isn't a value, it uses the NOW() function to get the current time.
Example workbook attached.
Jul 15 2020 06:30 PM