How to Count a value in a drop down / multi-selection list?
Hi,
I'm wanting to count the total amount time this value "VAVE" is being assigned to a drop down column. I'm using a summary sheet to collect this data using formulas.
So in the request type column(drop down list) I want the total in this sheet. I also want a total by the Brand.
I keep getting an incorrect number, like 48 or 0. The correct answer should be 6 total.
I've tried these formulas:
=COUNT({CPR Request Type}, "VAVE")
=COUNTIFS({CPR Request Type}, "VAVE")
Work Smarter, Not Harder
Best Answers
-
@Shawn_K2 UGH I make a mistake. I copied your formula without looking at it close enough 😜
try =COUNTIFS({CPR Request Type}, HAS(@cell, "VAVE"))
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
=COUNTIFS({CPR Request Type}, HAS(@cell, "VAVE"), {CPR Brand}, HAS(@cell, "ING"))
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Answers
-
Try this:
=COUNT({CPR Request Type}, HAS(@cell, "VAVE"))
That assumes that {CPR Request Type} represents the entire column in the sheet that you are referencing.
Read more about HAS(): https://help.smartsheet.com/function/has
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
Hey @Darren Mullen It is still counting too high. This came back with 48. The answer should be 6.
And yes {CPR Request Type} is the column.
Work Smarter, Not Harder
-
@Shawn_K2 UGH I make a mistake. I copied your formula without looking at it close enough 😜
try =COUNTIFS({CPR Request Type}, HAS(@cell, "VAVE"))
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@Darren Mullen That worked! Thank you!
Now if I want to do the same formula but also sort by the Brand column?
Work Smarter, Not Harder
-
@Shawn_K2 Add a 2nd criterion range and criterion https://help.smartsheet.com/function/countifs
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@Darren Mullen Getting the 0 again. I've tried to place the <> and I get 0 or errors.
=COUNTIFS({CPR Request Type}, HAS(@cell, {CPR Brand}, "ING"))
Work Smarter, Not Harder
-
=COUNTIFS({CPR Request Type}, HAS(@cell, "VAVE"), {CPR Brand}, HAS(@cell, "ING"))
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 494 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives