Count status -Close,Rejected,Open by month, year

Hi
I am quite new to Smartsheet. I have attached the input and desired output that I need. Thanks and really appreciate it
Best Answer
-
I would suggest the opposite structure for your table data. Use a date type column with the first of each month that you want to track for entered, and use separate columns for each status.
Then your formula would look along the lines of
=COUNTIFS({Source Sheet Status Column}, @cell = "Open", {Source Sheet Date Column}, AND(IFERROR(MONTH(@cell), 0) = MONTH([Date Column]@row), IFERROR(YEAR(@cell), 0) = YEAR([Date Column]@row)))
Answers
-
I would suggest the opposite structure for your table data. Use a date type column with the first of each month that you want to track for entered, and use separate columns for each status.
Then your formula would look along the lines of
=COUNTIFS({Source Sheet Status Column}, @cell = "Open", {Source Sheet Date Column}, AND(IFERROR(MONTH(@cell), 0) = MONTH([Date Column]@row), IFERROR(YEAR(@cell), 0) = YEAR([Date Column]@row)))
-
Hi Paul
Thanks for the help. It works now. Really appreciate your help in this.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!