Stuck on Multi-criteria countif function


I am trying to find active pilots at risk by using countif to find the following in a range:


Pilot Execution

Pilot Summary

Approval to Launch

That have a status of red or yellow

Is there anyone great at these who can help?

This is what I have so far:

=COUNTIFS(Sheet - Pilot and Readiness Pipeline - Pilot1, CONTAINS("1 - Planning",@cell), ({Pilot and Launch Pipeline Status}, OR(@cell = "red", @cell = "yellow"))

Note that the second part works: ({Pilot and Launch Pipeline Status}, OR(@cell = "red", @cell = "yellow"))

I can't figure out how to combine the two criteria.

Thanks a million!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!