How to Count a value in a drop down / multi-selection list?

Shawn_K2 ✭✭✭
edited 06/26/23 in Smartsheet Basics


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")


Best Answers