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

SmartSheet Newbie

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))

Paul Newcome

It looks like you have some extra parenthesis tucked in there. Lets start by cleaning a few things up to see if that helps any...

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

Mike TV

@SmartSheet Newbie

Please provide a screenshot of both sheets (without sensitive data) so we can see what column names you're working with.

SmartSheet Newbie

Paul Newcome

It looks like you have some extra parenthesis tucked in there. Lets start by cleaning a few things up to see if that helps any...

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