Count the number of "In Progress" within the last 30 days

I need to count the number of "In Progress" request that were created within the last 30 days in a referenced sheet, in a separate metrix sheet. Below is what I tried to use.

[Primary Column]@row equals "In Progress"

=COUNTIFS(({SD - Request Tracker Range 1}, [Primary Column]@row), ({SD - Request Tracker Range 2}, <= 30))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!