Want a date input like =NOW() NOT TO AUTO UPDATE - Want a time Stamp
Posted by Phil on May 16, 2001 2:28 PM
I want to be able to time stamp a cell. I am using a "check box" from the forms menu to set "true" or "false" statements in cell "Z6" then in cell "Z10" I put =IF(Z6=TRUE,NOW(),"Not Stamped").
PROBLEM: When I calculate or enter data in any other cell cell "Z10" automatically updates with the current date and time (as the NOW statement should).
What can I use to have it update ONLY when I want and not whenever anything is done on the sheet?