Formula for counting task status by Sub team


Hi, I want to calculate the number of 'Complete', 'In Progress' tasks by each sub team. The Sub Team column is a multiple value drop down. Need help with formula to calculate.

Thanks in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!