Calculate upcoming tasks



I am trying to calculate the number of upcoming tasks in the next 15 days.

This formula works BUT the number returned is not correct. Any idea why?

=COUNTIFS(Milestone:Milestone, CONTAINS("V2", @cell), [Published due date]:[Published due date], =TODAY(+15))

"V2" is in a text column with no other text in it

I have tried using HAS instead but I get the same number returned.

Below an example, there should be at least 6 tasks returned but I get 5 with the formula above

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!