Formula to have a check box ticked when a date is reached

Hello Smartsheet Community,

Would anybody know how to write a formula to tick a check box once a date in another column is reached.

Many thanks in advance😊

Best Answers


  • Hi AndrĂ©e,

    Thanks very much for the input. The formula works perfectly, but it ticks any cells without a date. How could I overcome this ? If I fill the cell with text it goes INVALID and I cannot fill the cell with a date that is far in the future.

    Thanks again.

  • Yep that sure did it :).

    I could probably benefit from learning some of this. You wouldn't have to bail me out all the time then.

    Thanks very much again Andrée.

  • AndrĂ©e StarĂ„
    AndrĂ©e StarĂ„ ✭✭✭✭✭✭


    I'm always happy to help!

    Have a fantastic week!


    Andrée StarÄ | Workflow Consultant / CEO @ WORK BOLD

    W: | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Help Article Resources