Count the values in a drop-down list
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
Answers
-
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?
-
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
-
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.
-
Thank you. Will do.
