Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I've got a spreadsheet in Google Drive and one column is meant for the date the entry is made. Is there a button to do this? I'm aware of the functions =NOW() and =TODAY() but their description says "the value is updated when the document recalculates". However I reopened the document a few minutes latter and it still had the same time. Why is this?

It would be even easier that when I start typing in a new row the column for the date auto-populates.

share|improve this question
    
So, you know how to downvote, perhaps now you can accept one of the ansers given. –  Jacob Jan Tuinstra Aug 24 '13 at 6:39
add comment

2 Answers

up vote 1 down vote accepted

I was able to reproduce your findings, however, opening a spreadsheet doesn't result in a re-calculation.

Press Ctrl + R to recalculate the entire sheet.

There's one concern about this method: it changes all NOW() formula's into the current date/time.
Therefore you might want to consider pressing Ctrl + ; in the creation date cell and add the date manually.

Reference: Recalculation of Sheet

share|improve this answer
    
So the difference between Ctrl+R and Ctrl+; is +R updates all the NOW() and +; does not? –  Celeritas Jul 24 '13 at 19:21
    
Ctrl+R gives you a solution to your problem, but it might create one at the same time. That's why I added the Ctrl+; because this adds the date "physically". –  Jacob Jan Tuinstra Jul 24 '13 at 19:30
add comment

Another option to consider is =GoogleClock(). This function differs somewhat from =NOW() in that it has a granularity of one minute (rather than one second), but it is guaranteed to update each and every minute, and be correct (to the nearest whole minute) on opening/refreshing the spreadsheet.

If you use:

=NOW()+GoogleClock()*0

you will have a granularity of one second, it will update with every edit, and be no less than one minute off when you open the spreadsheet. But it will also update every minute regardless of editing, which may not be desirable.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.