F
FT OFFICE
Can anyone tell me how to create a column that will automatically enter the
time each time an entry is made?
Example: Any time anything is entered into A2, K2 will auto fill in the time
and keep that time rather than updating with the system clock.
I had this in the K2 cell...IF(A2="","",NOW())
But that updates every time I save or refresh. I want it to stay constant
after the initial entry is made.
Any help would be greatly appreciated!
-Rob
time each time an entry is made?
Example: Any time anything is entered into A2, K2 will auto fill in the time
and keep that time rather than updating with the system clock.
I had this in the K2 cell...IF(A2="","",NOW())
But that updates every time I save or refresh. I want it to stay constant
after the initial entry is made.
Any help would be greatly appreciated!
-Rob