creating a "time stamp"

  • Thread starter Thread starter Dusty
  • Start date Start date
D

Dusty

Hi. I'm looking for help in creating a time stamp on a
spreadsheet.

Here's what I have:
shared spreadsheet
group 1 enters information for group 2
group 2 uses information, then "signs" it as complete.

I'm looking for a formula that will post the time when
group 2 "signs" the spreadsheet; the key is the time would
not change "on update" (or after saving) after
initial "stamp".

Currently using that is not working so the time does not
change:
IF(A2="Y",NOW(),"")

Thanks!
 
Back
Top