Last 7 Days Formula


I am trying to calculate how many IT tickets have been moved to the status of "completed" within the last 7 days. The formula returns a value of 6 but when I use the filters on the report, it returns the correct value of 2. Can someone help me with the formula so it returns the correct value of 2?

The formula I have is:

=COUNTIFS(Status:Status, "Complete", [Due Date - OVERALL]:[Due Date - OVERALL], >=TODAY(-7))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!