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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 218 Industry Talk
 456 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!