Using a checkbox in numbers- if,then, I want to display today's date if checked, and keep that date, the day it was checked, not the current day

I know this is delayed, but I had the same issue. I figured out a way to do it using Numbers 3.6.2:

Assuming A2 contains your checkbox and when unchecked you want to output a blank cell.

IF(A2=TRUE,NOW(), "")

So, if A2 is checked, then the cell will show the current date and time, else it will show nothing. Input values that correspond best to your uses.

EDIT: When using multiple checkboxes, they all seem to change to the current time when checked or unchecked. So this won't solve your or my issues.

this will not work. Numbers does not provide a timestamp. you can, however, enter the formula "=now()" in any cell, then copy that same cell, then paste (using the command "Edit > Paste Formula Results"

If you need a time stamp often,

make a single cell table with the formula (mentioned earlier).

and copy and paste as needed

Hi mdmayo,

The short answer is no, you can't do that.

If you double click in a cell you can use Menu>Insert>Date & Time.

If you want to search SG has written a automator service that will do the same.

quinn

Hi dstr0yr,

Just to be clear, NOW() will supply the current date and time and it will update when the table updates. So if you checked the box in A2 this afternoon and printed or saved a PDF you will have that time/date but if you open the file tonight you will show the current date/time and not when the checkbox was checked.

quinn