COUNTIFS for Projects Completed Within Past 90 Days

edited 12/09/19 in Formulas and Functions

For some reason I can't get this formula to work. I get 0 every time. Using a filter, I can see that number is incorrect. I want to count how many "Course" projects, per organization have hit complete in the past 90 days.


=COUNTIFS({Project Type}, "Course", {Organization}, [email protected], {Completed Date}, <=TODAY(-90))



  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    For the past 90 days, you would need >= instead of <=.

  • I checked that against a filter that I ran on the source sheet. when I use <=TODAY() and then close with >=(-90) I get the matching result to that of the filter. When I remove <=TODAY() and only leave >=(-90) I get a totally different number than what the filter shows.

    I am wondering where the discrepancy is.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!