COUNTIFS Blank & Not Blank


Formula shouldn't be too difficult, but I'm having some issues. What is the syntax for a function that counts is a cell is blank within certain criteria. Here was my attempt, but it was not working. Will also need the notblank version.

=COUNTIFS({Domain}, [Primary Column]@row, {Metric}, ISBLANK({Metric}))

Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!