Count formula results are off by 1

I build a simple formula to count results in a column

=COUNT(Status:Status, "Open/Active")

When i fist made the formula it should have reported 4 but it said 5. I made sure that nothing was hidden or had white on white text and even deleted all the rows out . When all rows were deleted out the formula returned value of 1

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!