How to count tasks occurring over a date range based on another column parameter selected
Trying to set up a formula to count tasks happening during a date range based on another cell drop down ie approved, not approved etc, any ideas?
Thanks
Answers
-
Hi Dan,
I just nest my COUNTIF's statements in my IF's statements and then nest them all together.... here is an example with 3 statuses and the final COUNTIF result is based on the all the statements nested together...
-
You can also create a COUNTIFS formula that checks each range. The following formula will check for any date within the calendar year, that also has "Approved" in the dropdown column. Just update the column names with your own column names. (Use brackets if your columns contain spaces or end in a number.)
=Countifs([Name of Date Column]:[Name of Date Column], > Date(2020, 01, 01), [Name of Date Column]:[Name of Date Column], < Date(2020, 12, 31), [Name of Dropdown Column]:[Name of Dropdown Column], "Appproved")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!