Hi there. I would like a date to be automatically filled out if I change or add an entry into any cell within the row. For example if I put a date into 'Initial Contact Date in H2, then F2 automatically enters the date in which I alter the row. I would like this to be for any entry across the row. Is this possible?
iMac 24″, macOS 14.1
Haley,
Numbers does not perform like a database where you can time stamp information.
You can keep a single-cell table to the top with the formula :
=now()
then when you want to time stamp something, select that cell, copy
then use the menu item "Edit > Paste Formula Results" to manually time stamp an row.
Haley,
Numbers does not perform like a database where you can time stamp information.
You can keep a single-cell table to the top with the formula :
=now()
then when you want to time stamp something, select that cell, copy
then use the menu item "Edit > Paste Formula Results" to manually time stamp an row.
No. A cell cannot monitor the activity of another cell, it can only obtain its current value for a calculation.
If you forget the long keyboard shortcut for date stamping a cell you can always click the cell and in the menu go to Table > Insert Current Date.
You can also change that shortcut if you want, in fact add a keyboard shortcut to any menu item.
Create keyboard shortcuts for apps on Mac - Apple Support
But be careful to avoid conflicts with other existing shortcuts.
SG
Hi Hayley,
Just putting my spoke in the wheel.
I tested date stamp in Numbers by formatting Column B as:
Format Panel > Cell > Data Format > Date & Time > Date (in my Region, weekday, day of month, year) and Time as hour, minute, second, am/pm.
I did that to test how Numbers handles a date stamp. I included Time so that I won't have to wait until tomorrow to find out if it is an automatic update like the NOW or TODAY functions.
Cell B2 Menu > Table > Insert Current Date works as intended. The date is correct, and the Time is 12:00:00 am (midnight at the start of that day).
Cell B3 Menu > Table > Insert Current Time works as intended.
Cell B4 (some minutes and seconds later) Menu > Table > Insert Current Time works as intended.
My test confirmed that Insert Current Time is a Date & Time stamp that does not affect previous Date & Time stamps in the way that the functions NOW and TODAY automatically update.
If the Date part works for you, you don't need to display the Time part.
Regards,
Ian.
Thank you so much for your prompt reply.
Is there any way I can keep track of the last contact date with a client automatically? I have so many boxes across the row, if I have to go back and forth, it's hard to keep track.
You could put the last contact in the second column and set the header columns count to 2, and keep the headers frozen.
This way, the column would always be visible even if you scroll to the right.
Keyboard shortcut Shift-Control-Command-D enters the current date directly.
Formula inserting date for last entry.
