Formulas

Options

I am working on counting if criteria is met, but want to skip if the cell is blank. I have two formulas that work separately, but when I combine them I get an error.

CountIf

=COUNTIF([Connected to Confirmed]@row, "<7")

Skipping the blank cells

=IFERROR([Connected to Confirmed]@row, "")

I'm not sure what I'm doing incorrectly but I have the formulas counting based on a formula from another cell.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!