Using COUNTIF in Sheet Summary

I am trying to use a COUNTIF formula in the Sheet Summary. I have a column called, "Current Project Status." I want to count the total number of times the word "Operational" appears in that column. I have entered this into the field with no luck; "=COUNTIF(Current Project Status:Current Project Status,Operational)" I have tried quotation marks around the word Operational. I've tried spaces on either side of the colon. I don't know what it is, but I have terrible luck getting formulas to work on the Sheet Summary. In case this is an issue, some of the data in this column is from cell links.

Any help is appreciated.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!