Countifs with and

HH_BE1894 ✭✭✭✭
edited 07/12/23 in Formulas and Functions

I'm working on a metrics sheet and trying to count all the instances where a project is assigned to a particular person (metric@row) within the current year (parent cell) AND ONLY if the project status is New, In Progress or Approval Pending (Metric21, Metric22, and Metric23 in metrics sheet).

My formula before factoring in the project status:

=COUNTIFS({Broth Launch - Responsible}, FIND(Metric@row, @cell) >= 1, {Broth Launch - Year}, PARENT())

How do I edit this formula to return a sum of only the projects where {Broth Launch-Status} equals Metric21, Metric22 or Metric23?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!