COUNTIF Using Open-Ended Range Formula (Not Working)
Comments
-
If your column has spaces in the name, you need to add brackets in the formula. Try this:
=COUNTIF([Test Result]:[Test Result], Status1)
-
That was the problem. Thanks!!!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!