Formula Help- Check Box if Date is tomorrow
Options
aelmore
✭
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:
Comments
-
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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!