Count if cell has name and checkbox not checked

Options

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.

Thanks,

AL

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!