Formula Question

LK Shook
LK Shook ✭✭
edited 02/05/24 in Formulas and Functions

I need to create a count formula that counts an item from a multi-dropdown column in another sheet. Not related to a string of information. Can anyone help? Thanks.

Answers

  • KPH
    KPH ✭✭✭✭✭✭

    Do you want to count the instances of a particular text string within a multi-select 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.

  • KPH
    KPH ✭✭✭✭✭✭

    Hi @LK Shook

    Did I correctly understand what you needed? Did it work and make sense?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!