Multi Step Formula - Monthly Counts
I'm trying to create a metric sheet that looks at multiple values, and records that info in a cell each month.
If I have 5 members join membership A, in October 2020 it would count the member type + number of members in the month of October 2020. Once I nailed down the proper formula I would apply it starting Jan 2019.
I was thinking a COUNTIFS would be the way to go, but I'm not able to figure out the year component. This is what I have so far:
=COUNTIFS({ERG MEMBERSHIP SHEET Able}, true, [{ERG MEMBERSHIP Joined Date}, 12 / 0 / 2020])
I assume it's the date portion I have incorrect. Any suggestions?
Thanks
Best Answer
-
If you're looking to count by month it would be:
=COUNTIFS({ERG MEMBERSHIP SHEET Able}, true, {ERG MEMBERSHIP Joined Date}, MONTH(@cell) = 10)
This formula assumed the Joined Date is in the Date format and that the month you're looking for is October (the 10th month).
Answers
-
If you're looking to count by month it would be:
=COUNTIFS({ERG MEMBERSHIP SHEET Able}, true, {ERG MEMBERSHIP Joined Date}, MONTH(@cell) = 10)
This formula assumed the Joined Date is in the Date format and that the month you're looking for is October (the 10th month).
-
Hi David
Thanks for that feedback! The adjustment you provide worked well. I also added in the year and sharing the final formula incase someone out there needs it.
=COUNTIFS({ERG MEMBERSHIP SHEET Able}, true, {ERG MEMBERSHIP Joined Date}, MONTH(@cell) = 10, {ERG MEMBERSHIP Joined Date}, YEAR(@cell) = 2020)
Thanks again!
-
No problem. Glad it is working.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!