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 for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!