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.
Tags:
Answers

See below formula.
Replace the column names (bolded text) with your specific columns you wish to count.
=COUNTIF([column1]@row:[column9]@row, CONTAINS("below", @cell))
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!