Save The Date Game Download
Jaskon Farr
There is no timestamp feature built into Numbers. You could add an Applescript (perhaps called Update Timestamp and Save) which could do this. You would have to write this Applescript or see if SG is willing to help.
As I'm sure you know but may not have thought of in this context, Finder's Get Info will show you when you last modified the document. You don't even have to open the document to examine this date. Just highlight the filename and Command-I.
I guess I left out this critical detail: The reason I need the date there is that I print this out for my wife, who isn't computer-savvy. I'm trying to avoid the situation where she looks at the printout, and the date, and wonders why the numbers seem out-of-wack.
It's my opinion that you should annotate every log entry with the current date and time, for reasons separate from this flag for your wife. After that, it's a simple master to have the display cell find the MAX date entry in the log and display it. I do this with a document that tracks regular invoice payments such as credit card bills. Each vendor gets a log sheet, and I have a Top Sheet that summarizes when each vendor was last paid, how much, confirmation code, etc. To top sheet works by finding the rows with the MAX dates in the individual sheets and pulling them into the summary.
The 'Today' Automator Service (actually a date-time stamp, i.e. both date and time, so that's a bit of a misnomer; it's really 'Now') can be downloaded here. (Dropbox download). Doubleclicking the .workflow package will move it to the Library>Services folder, making it show up in the Services menu (you may have to click 'download anyway' in System Preferences > Privacy & Security. Like any other menu item it can then be assigned a keyboard shortcut at System Preferences > Keyboard:
This requires creating (or editing) a template in which you have formatted the target cell as Date and Time displaying the date part in the format you want to see it (and the time part as you want it to appear, or not appear), then Selecting the file that will contain the date and Saving the file as a Template.
760c119bf3