Formula Help- Check Box if Date is tomorrow

Options
aelmore
aelmore ✭
edited 12/09/19 in Formulas and Functions

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:
· Share on FacebookShare on Twitter

Comments

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

    In a checkbox column, this:

    =[Date]@row = TODAY(1)

    or

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

    works

    I hope this helps.

    Craig

    · Share on FacebookShare on Twitter
  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    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. 

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!