Formula to count all instances of a value in specific column from another sheet

SKW

I am trying to create a formula that references another sheet and totals the number of times a specific value shows up in a column that allows multiple values (from a dropdown menu). I am using =COUNTIFS({insert reference to column on other sheet}, HAS(@cell, "insert specific value")), but it only counts the number of times my specific value shows up as the only value in the cell, not when it is one of 2 or more selections. What am I doing wrong?

AravindGP

Hi @SKW

HAS in Smartsheet looks for an exact match, i.e., only that specific value. Replace it with CONTAINS and you should get the result.

=COUNTIFS({insert reference to column on other sheet}, CONTAINS("insert specific value", @cell))

SKW

thank you!