Creating less than today check box

I want to create a formula that has a checkbox that will check if the due date column is between today and 7 days. It works but when i format it to the entire column it checks off every because because it considers that if the due date column is blank it's less than today. My formula is:

=IF([Proposed Due Date]@row < TODAY(7), 1)

Please help

Tags:

Comments

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

    You can avoid that in this case by making sure you have "between today and ...", which your formula neglects:

    =IF(AND([Proposed Due Date]@row < TODAY(7), [Proposed Due Date]@row >= TODAY()), 1)

    If in the future this would not be the case (show me things up to a week away or  in the past) then ISDATE() will help.

    Craig

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!