Hello!
I searched the internet for a solution to my problem and thought I had it, but now that it's a month later and I went to check on my spreadsheet, I realize that my function no longer works.
When I enter text in Column C, I want column A to record the date of the entry. I want this time stamp to remain static.
This is what I have currently:
=IF(C3<>"",IF(A3="",NOW(),A3),"")
So that basically if C3 is empty, no time stamp appears. If C3 is full and a time stamp has already been generated in A3, A3 remains as A3 and is not updated.
Not sure what the <> mean but I found it online written that way for this type of problem. When I substitute = for <> I get an error about the function.
Any ideas as to how to get your time stamp to remain static for entries?
Thanks!
Bookmarks