How do I add a timestamp on a condition?

What formula would I use if I wanted this:

If A1 is greater than 1 then B2 equals the time that I entered a # in cell A1

Hello,

Thanks for the link. I found that this formula worked:


=IF(A1="","",IF(B1="",NOW(),B1)) along with choosing Tools/Options/Calculation (Preferences/Calculation for Macs) and check the Iteration checkbox.

My only problem is that when you update cell A1 it does not update cell B2 to the current time. Is there a way to fix it so that it updates to the last change in cell A1?

awesome, thanks!

oh wait, how would I reference that code so that if I made a change in spreadsheet 1 it would add the date in those cells in spreadsheet 3

this is the code I used:

Please Login or Register  to view this content.

hmmmm, didn't work