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}, Metric@row, {Completed Date}, <=TODAY(-90))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!