Count if cell has name and checkbox not checked


Hi everyone,

I would like to count if a cell has a certain name in it; only if the done checkbox is not checked. I have tried several formulas found online; without success.

I can find the name; and count the unchecked boxes. Just cannot seem to connect the two.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!