Formula Question
I need to create a count formula that counts an item from a multidropdown column in another sheet. Not related to a string of information. Can anyone help? Thanks.
Answers

Do you want to count the instances of a particular text string within a multiselect dropdown column?
If so, the COUNTIF formula with a HAS function will probably do the trick. Something like this:
=COUNTIF([Column Name]:[Column Name], HAS(@cell, "Thing to Count"))
In this example, that formula would return "4" as "Thing to Count" appears 4 times in the Column called Column Name:
You could remove the "Thing to Count" from the formula and instead put this into another column like this:
The formula in the Count column is
=COUNTIF([Column Name]:[Column Name], HAS(@cell, [Look up]@row))
You replace the text to look up with a reference to the cell that contains the text.

Hi @LK Shook
Did I correctly understand what you needed? Did it work and make sense?
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!