Create formula for monthly count of extensions
Currently tracking our active project extensions. If we get an extension in a particular month I want to be able to capture how many extensions we get within each month.
Best Answer
-
@asha.D That is the correct formula but you're missing a comma between {month} and "Jan".
Answers
-
=COUNTIFS( {X}, "Yes", {Y}, 1, {Z}, "Jan")
Where:
X - Extension reference nameY - Active Status checkbox
Z - Month
...
-
Hello and thank you for responding to my post.
I tried the formula above for my Active project sheet and wasn't able to get retrieve the data correctly with the formula provided above. Does anyone have any feedback as to what I should change in my formula to be able to capture each month count of extensions?
-
@asha.D That is the correct formula but you're missing a comma between {month} and "Jan".
-
Awesome thank you, it WORKED!
Help Article Resources
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
Check out the Formula Handbook template!