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
-
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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!