You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How to auto-fill the current date in a cell when the adjacent cell in that table is filled in?

How to auto-fill the current date in a cell when the adjacent cell in that table is filled in?

Posted on Jan 18, 2021 6:16 AM

Reply
Question marked as Top-ranking reply

Posted on Jan 18, 2021 12:18 PM

The following formula will place today's date in C3 when cell B3 is filled.



That's


IF(ISBLANK(B3),"-",TODAY())


However, if you close the spreadsheet and open it again tomorrow, it will display tomorrow's date. If you're looking to create an automatic and permanent timestamp, I'm not sure that it's possible.

3 replies
Question marked as Top-ranking reply

Jan 18, 2021 12:18 PM in response to KeyserSoze05

The following formula will place today's date in C3 when cell B3 is filled.



That's


IF(ISBLANK(B3),"-",TODAY())


However, if you close the spreadsheet and open it again tomorrow, it will display tomorrow's date. If you're looking to create an automatic and permanent timestamp, I'm not sure that it's possible.

Jan 19, 2021 11:52 AM in response to KeyserSoze05

It is not a built-in feature. It could be done with an AppleScript written specifically for your exact requirements and your exact table, running in the background, waiting to be triggered by data entry into any of the specific "adjacent" cells you want it to watch and filling in the specified corresponding cell with the date. You would have to start the script before entering any new data. It would not be very practical but it could be done, I think.


Probably the most practical thing would be to assign a simpler keyboard shortcut to Insert Current Date (found in the Table menu) and insert the date yourself.

How to auto-fill the current date in a cell when the adjacent cell in that table is filled in?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.