CountIFs projects are within a date range.
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,
Answers
-
Hi,
You can use automation to solve this issue
-
I am attempting to add this to a Metrics sheet so I can add this metric to my dashboard
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!