CountIFs projects are within a date range.


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,


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!