How do I count occurrences of a word in a row?

I'd love to count the number of times the word "below" occurs in a row.

Apologies for the simplicity of this question, I'm very new to Smart Sheets!

This word could occur as either "below target" or "significantly below target", but I'm hoping just to count ALL instances of "below" once if that's possible.

I've tried =COUNTIF(@ROW, below)

=COUNTIF(@ROW, "below")

=COUNTIF(@ROW, {below})

and all are unparseable, so I'm misunderstanding something very basic here.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!