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 14, 2013 9:27 AM in response to Yellowbox

I have tried this, but end up with an error (for cell E2):

Argument 1 of IF expects a Boolean, but cell D2 contains a date.

Any idea what I have done wrong?

Thanks,

Peter

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Static date on Checkbox TRUE?

Welcome to Apple Support Community

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

Learn more Sign up