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

This looks like just a syntax error.
If your rating is numeric, try this:
=COUNTIF({Develop ONE Process Map Template}, =1)
If the 1 is stored as text, try this:
=COUNTIF({Develop ONE Process Map Template}, "1")
Also make sure your range ({Develop ONE Process Map Template}) is only referencing the single column you're looking for the rating values to be in.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Glad I could help. It can be easy to overthink things when working on formulas in Smartsheet! Many times simpler is better.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers

This looks like just a syntax error.
If your rating is numeric, try this:
=COUNTIF({Develop ONE Process Map Template}, =1)
If the 1 is stored as text, try this:
=COUNTIF({Develop ONE Process Map Template}, "1")
Also make sure your range ({Develop ONE Process Map Template}) is only referencing the single column you're looking for the rating values to be in.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Thank you. I was a really stupid mistake on my end.

Glad I could help. It can be easy to overthink things when working on formulas in Smartsheet! Many times simpler is better.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!