Form Summary Sheet


I have a form summary sheet that is rating items one to 9.

I want to create a Metric that will count the number of "1" or "2" or '3" etc thru 9 for each item.

The formula I have been using is =countif({Develop ONE Process Map Template},contains("1",@cell)).

That does not seem to be working. I also tried =countif({Develop ONE Process Map Template}=,(1).

That seemed to work but the column I was referencing kept changing as I worked my way through the Metric sheet.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!