I want to count the number of times values appear in a multiselect column

Amanrique

I am not sure how I can combine INDEX MATCH, HAS, and COUNTM functions for me to be able to count the number of times different values appear in multiselect fields

Trish Dillon

@Amanrique - to count the values in a multi-select you have to use CONTAINS and indicate what you want to reference.

Example:

😀

Trish Dillon

@Amanrique - to count the values in a multi-select you have to use CONTAINS and indicate what you want to reference.

Example:

😀

Amanrique

Hi Trish,

This worked!! ahhh thank you so much!!!!

Trish Dillon

https://community.smartsheet.com/discussion/comment/331866#Comment_331866

Glad to help! 😁