Formula Help- Check Box if Date is tomorrow

edited 12/09/19 in Formulas and Functions


I need a formula so that if a date column is the next day, a box is checked. This is what I've started, but I can't figure out how to say- if the date is tomorrow... 


Any ideas? Thanks!



  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    In a checkbox column, this:

    =[Date]@row = TODAY(1)


    =IF([Date]@row = TODAY(1),1,0)


    I hope this helps.


  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Hi Amy, One question. Are you wanting that checkbox to remain checked if the date exceeds tomorrow? For example, if I have a row and its checked because tomorrow is the due date. What do you want the checkbox to do when the date = today?  Or what about if it exceeds the date, do you still want it checked?

    IF so, you might consider: 

    =Date@row <= TODAY(1) 

    This will check the date in the row and compare it to today plus a day, and if the date is less then it will remain checked. 

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!