Project by Country & Schedule Health
I am trying to populate a sheet (to create a widget for my dashboard). I have a project intake form which has the country and overall project health populated. I want to then create a table that counts all of the green, yellow, and red for each country (Japan, Germany, etc). I tried using Index/Match formulas but to no avail - I then tried COUNTIFS(INDEX(MATCH but it keeps erroring out. Can someone help?
Help Article Resources
Check out the Formula Handbook template!