# Formula Help- Check Box if Date is tomorrow

Options
edited 12/09/19

Hi!

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...

=IF(date:date=????,(1))

Any ideas? Thanks!

Amy

Tags:

• ✭✭✭✭✭✭
Options

In a checkbox column, this:

=[Date]@row = TODAY(1)

or

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

works

I hope this helps.

Craig

• ✭✭✭✭✭✭
Options

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!