Count if exclude a column with blanks

I would like to summarize information on how many green "progress" icons we have but exclude those with also a green "state" icon. I tried this but it didn't work:

=COUNTIFS(CAPABILITY:CAPABILITY, CONTAINS("Development", @cell), [Progress Alert]:[Progress Alert], "Green", State:State, NOT(@cell = "Gray"), State:State, NOT(@cell), [Cross Functional Team or Activity]:[Cross Functional Team or Activity], "INTEROPERABILITY")


Any ideas?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!