How do I count multiple types in a column?
This is my current formula that works:
=COUNTIFS({STATUS}, "Completed", {AUDIENCE CATEGORY}, HAS(@cell, "All Employees"), {QUARTER}, HAS(@cell, "Q1'23"))
But now, I need the formula to count multiple quarters (see the last part of the equation). I need it to pull Q1'23, Q2'23, Q3'23, Q4'23. How do I add those on? ...
Thank you!
Best Answer
-
Hi @nicoleejordannn If your Quarter column has various values, you'll need the OR operator to check to see if QUARTER has "Q1'23" or "Q2'23" or...
=COUNTIFS({STATUS}, "Completed", {AUDIENCE CATEGORY}, HAS(@cell, "All Employees"), {Quarters}, OR(HAS(@cell, "Q1'23"), HAS(@cell, "Q2'23"), HAS(@cell, "Q3'23"), HAS(@cell, "Q4'23")))
Is your Quarters column a multi select dropdown? If so, the above will work. If it isn't, let me know.
@A Rose your suggestion would work, but it would add the requirement of all quarters to exist in the row before that row would be counted.
Answers
-
Hi @nicoleejordannn,
Can you add after: {QUARTER}, HAS(@cell, "Q1'23"), {QUARTER}, HAS(@cell, "Q2'23") etc. ?
Thank you,
-
Hi @nicoleejordannn If your Quarter column has various values, you'll need the OR operator to check to see if QUARTER has "Q1'23" or "Q2'23" or...
=COUNTIFS({STATUS}, "Completed", {AUDIENCE CATEGORY}, HAS(@cell, "All Employees"), {Quarters}, OR(HAS(@cell, "Q1'23"), HAS(@cell, "Q2'23"), HAS(@cell, "Q3'23"), HAS(@cell, "Q4'23")))
Is your Quarters column a multi select dropdown? If so, the above will work. If it isn't, let me know.
@A Rose your suggestion would work, but it would add the requirement of all quarters to exist in the row before that row would be counted.
-
@Ryan Sides I didn't have the quarters in the dropdown but added it and it worked perfectly. Thank you so much!
-
@nicoleejordannn Glad to hear it!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!