Count the values in a drop-down list

rodel.policarpio

I need to count the number of values in a drop-down list (cell/row, not column) regardless of any of the values are selected. I am using this formula but it's counting the whole column not row/cell. =COUNTFS(Property Completed, CONTAINS("PS", @cell)).

Any help would be appreciated. Thanks in advance

Courtney S.

The COUNTM function gives you the number of answers that were selected in a multi-select dropdown field. Is that what you're looking for, or something else? https://help.smartsheet.com/function/countm

rodel.policarpio

No. I need the count on that list regardless or not if any item has been selected. Let's say I have 10 values to select, I need to pull that 10. If 4 has been selected, I still need that total count of 10 to return. Thanks

Courtney S.

The dropdown lists lives in the column properties. I don't think there's a way to use a formula to count the number of options listed in the column properties. I think you'll have to manually enter the total number of options that column has.

rodel.policarpio

Thank you. Will do.