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

Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list