CountIFs projects are within a date range.

Alexi Resendiz

Hello,

Need assistance, I am referencing a second sheet and I am attempting to count all projects that are estimated to start within 30-60 days. The second criteria is that I only want to count the cells that have a blank cell under the Actual date.

I have used the following and receive error =COUNTIFS({Tracker (BAU) Range 2}, AND(@Cell >= TODAY(31), @cell <= TODAY(60)),{Tracker (BAU) Range 3}, ISBLANK(@cell))

Thank You,

Alex Argumedo

Hi,

You can use automation to solve this issue

Alexi Resendiz

I am attempting to add this to a Metrics sheet so I can add this metric to my dashboard

Alex Argumedo

https://community.smartsheet.com/discussion/comment/294572#Comment_294572

Automation should work on any sheet, you can also create an "auxiliary" column (hidden) in your source sheet, then pull the column to your Metrics sheet, apply the automation, and then get that column for your dashboard from your Metrics sheet