Count tags within a multi select column

Hello,

What formula would I use count a multi select option with a certain condition? For example in this data set, I want to count the number of times IP1 occurs in Phase 1b:


Thanks!

Answers

  • Ric T
    Ric T ✭✭✭✭✭✭

    Hi @Heaven Casher,

    Try this formula:

    =COUNTIFS(Groups:Groups, HAS(@cell, "IP1"), Phase:Phase, "Phase 1b")

    Note, you'll need to modify the formula to fit the name of your columns. In the formula above, I've named the column which contains your multi-select values as "Groups", and the column which contains the different phases as "Phase".

    Cheers,

    Ric

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!