Count if all, cells contain a specific word.


I am still new to using formulas and I am hoping someone can help with finishing this one. I have an information sheet and a metrics sheet to build a dashboard off.

On the dashboard metric sheet, I am wanting to count the cells in a column ion the data sheet that contain the text "PPM" the column I am referring to is a dropdown and allows multi. Currently I have

=COUNTIF({Range 1}, [Column1]@row)

(Row cell contains the word I am searching for.)

That currently returns count for cells that only contain the @cell, not cells with multi values within them.

What is the extra part to the formula I would need? please help?

Thank you


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!