Count tags within a multi select column
Options
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

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 multiselect values as "Groups", and the column which contains the different phases as "Phase".
Cheers,
Ric
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!