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

Amanrique ✭✭

06/02/22 in Formulas and Functions

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

Tags:

• Formulas

0 · Share on FacebookShare on Twitter

Best Answer

• 

  Trish Dillon ✭✭✭✭✭✭

  06/02/22 Answer ✓

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

  
  

  Example:

  

  😀

  Thanks!

  
  

  Trish Dillon

  https://www.linkedin.com/in/trishdillon/

  1 · Share on FacebookShare on Twitter

Answers

• 

  Trish Dillon ✭✭✭✭✭✭

  06/02/22 Answer ✓

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

  
  

  Example:

  

  😀

  Thanks!

  
  

  Trish Dillon

  https://www.linkedin.com/in/trishdillon/

  1 · Share on FacebookShare on Twitter
• 

  Amanrique ✭✭

  06/02/22 edited 06/02/22

  Hi Trish,

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

  1 · Share on FacebookShare on Twitter
• 

  Trish Dillon ✭✭✭✭✭✭

  06/02/22

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

  Glad to help! 😁

  Thanks!

  
  

  Trish Dillon

  https://www.linkedin.com/in/trishdillon/

  0 · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list