Hello,
I am trying to add values in column A and have the a date/time stamp in column D. I have a question and my searches have not been helpful or the results are outdated.
IF(ISBLANK($A3),"",NOW())
So the above formula works, if cell A3 is empty the date/time cell (D3) is blank. I enter a value in A3 and then D3 shows the date and time of the entry. However any change to anything in the spreadsheet updates the time stamp. So I found that I can copy the formula and then 'Paste Formula Results' it will show a static value and not update.
So I am looking to enter a new value every day, while not changing the previous time stamps and not having to 'Paste Formula Results' every time.
Ideas? Thanks!
I am trying to add values in column A and have the a date/time stamp in column D. I have a question and my searches have not been helpful or the results are outdated.
IF(ISBLANK($A3),"",NOW())
So the above formula works, if cell A3 is empty the date/time cell (D3) is blank. I enter a value in A3 and then D3 shows the date and time of the entry. However any change to anything in the spreadsheet updates the time stamp. So I found that I can copy the formula and then 'Paste Formula Results' it will show a static value and not update.
So I am looking to enter a new value every day, while not changing the previous time stamps and not having to 'Paste Formula Results' every time.
Ideas? Thanks!