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, smartsheetguru.com
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, smartsheetguru.com
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, smartsheetguru.com
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, smartsheetguru.com
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, smartsheetguru.com
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, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives