COUNTIFS keep coming back as zero


Hello all,

I'm trying to do a count of all projects in Green (later for Yellow and Red) status across 4 different team sheets and this is the formula that I came up with :

=COUNTIFS({Team B Range 1}, FIND("Green", @cell) > 0, {Team F Range 1}, FIND("Green", @cell) > 0, {Team G Range 1}, FIND("Green", @cell) > 0, {Team V Range 1}, FIND("Green", @cell) > 0)

it seemed to work fine for Team B but when I added the other teams it now constantly shows 0 as my result. Can someone point out where I went wrong on this? This is on a summary sheet if that helps.

Thank you


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!