Create metrics using a Date Range

Hello - I am trying to build metrics that show how many projects are created with specific quarters based off a Date completed column. Currently using this formula but it is not working:

=COUNTIFS({Project List Range 1}, "Closed", {Project List Range 3}, >=DATE(2020, 1, 1) <= DATE(2020, 3, 31))

Any helpful tips would be appreciated. The 1st argument is pulling data from a status column. When the project moves to closed, want to calculate how many projects closed within quarter 1, quarter 2, etc.

Thanks in advance

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!