Apple Event: May 7th at 7 am PT

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

Level 1

4 points

Static date on Checkbox TRUE?

Is there a way in Numbers to use a formula which enters the current date when a box is checked then keeps that date static?

Currently I'm using =IF(C2), TODAY, "") which will leave the requested date field blank when the checkbox is false, but enter TODAY when it's TRUE. Problem is that I want the date to reflect the day I checked that box, not the current date.

Thanks!

Numbers-OTHER, OS X Mountain Lion (10.8.3)

Posted on May 22, 2013 8:03 AM

16 replies

Sep 15, 2013 7:51 AM in response to Barry

Thanks. It's worth a try.

I have used Automator occasionally. Based on that experience, it will be a lot faster just to double click the date cell and insert Date and Time.