Count and Match


I am trying to count all the In Progress and Not started projects for each manager.

This formula is giving me per cell number... I am guessing its not adding up all the in Progress project or Not started

=INDEX({Engagement Data - Not Started}, MATCH([Team Manager]@row, {Engagement Data Manager}, 0))

Engagement data sheet has the details of the not started projects with the manager name.

I am counting on another sheet, all the NOT started projects on engagement data sheet.. for the Manager on Team Manager column in the range of engagement data sheet Manager column.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!