COUNTIF Using Open-Ended Range Formula (Not Working)

edited 12/09/19 in Formulas and Functions

I'm using the COUNTIF formula and am trying to set an open-ended range formula (see below). When I do so, I receive the error #UNPARSEABLE

=COUNTIF(Test Result:Test Result, Status1)

Is there any reason this wouldn't work?

I've attached a screenshot of how Test Result is defined.


Screen Shot 2018-11-26 at 1.15.39 PM.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!