Count If less than 50 rows

Jennifer Dewhurst
Jennifer Dewhurst ✭✭✭
edited 12/09/19 in Formulas and Functions

Can you do A COUNTIF formula with less than 50 rows or does Smartsheet default to 50?  If I delete the formula in the blank rows I get an "invalid reference" error message. 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!