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

Answers

  • Mitch@Enmach
    Mitch@Enmach ✭✭

    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.

  • Mitch@Enmach
    Mitch@Enmach ✭✭

    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Ă„ ✭✭✭✭✭✭

    Excellent!

    I'm always happy to help!

    Have a fantastic week!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | 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!