Rolling 90 Day Formula



I need to write a formula that will check a box if a date is in the next 90 days, and uncheck if the date has passed.

What I have so far is:

=IF(Start@row <= TODAY(90), 1,0)

So, if the Start date is less than or equal to 'Today' or the next 90 days, then check the box. If the Start date is not in the next 90, then leave the box unchecked.

My formula is not un-checking the box for dates in the past (past 'Today'), and is checking the box when the date is blank, which is not a desired outcome.

I tried a nested if statement to uncheck the box if the date is in the past, and blanks, but have not had success yet.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!