How to calculate number of request per month and status?
iamje
✭✭
Hi,
Data are:
Requested date formatted as 12/01/21 and Status such as New, In-Progress and Complete. Now I would like to calculate how may request do I have per month and the corresponding status. So basically considering only open requests.
thank you in advance for your help.
Answers
-
Assuming that by "open" you mean not "Complete", try this...
=COUNTIFS([Date Column]:[Date Column], AND(IFERROR(MONTH(@cell), 0) = 12, IFERROR(YEAR(@cell), 0) = 2021), Status:Status, @cell <> "Complete")
You would just need to change the bold numbers to match whichever year and month you are wanting to count for.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives