Countif checking for status and date range
jasonp
✭✭✭✭
Trying to create a data page based off another sheet to create counts of tickets (sync wit JIRA) that were closed withing a month. I have a column in the main sheet for "story", one for status "done" and one for update/close date from jira "Jira Update". So I need a count if where these items are true, plus where the date is Jan or Feb or Mar etc etc. Tired many combinations with no success. Anyone have ideas?
Comments
-
base countifs
=COUNTIFS({D2B Continuous Improvement Issue Type}, ="Story", {D2B Continuous Improvement Status}, ="Done")
how do I add to check the column
D2B Continuous Improvement JIRA Update
or
D2B Continuous Improvement Close Month
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 201 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives