Counting range of cells within row

jblunda ✭✭✭✭
edited 01/17/23 in Formulas and Functions

I'm trying to count the amount of times a cell within a row has a specific word:

=COUNTIF([Labelling)@row,[Training]@row), "Fail")

If Fail shows in any cell I want the function to result a readout of 1. If two cells have Fail, then the result would be 2, etc.

Instead of my expected result, I get #UNPARSEABLE in the cell. What am I missing?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!