IF formula to identify tasks for this week - missing tomorrow


I am using the formula below as a column formula under "This Week" to check the box when the start or finish date falls within this week so I can see which tasks I need to be working on week by week. It is capturing it correctly except when I have a task that starts and ends tomorrow (one day duration). How can adjust it to capture the missing day (see line 10)?

=IF(AND(TODAY()>= Start@row, TODAY()<= Finish@row), 1)

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!