Form Summary Sheet

gdooley@jbelectric

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.

Jeff Reisman

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.

COUNTIF Function | Smartsheet Learning Center

Jeff Reisman

https://community.smartsheet.com/discussion/comment/315772#Comment_315772

Glad I could help. It can be easy to overthink things when working on formulas in Smartsheet! Many times simpler is better.

Jeff Reisman

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.

COUNTIF Function | Smartsheet Learning Center

gdooley@jbelectric

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

Jeff Reisman

https://community.smartsheet.com/discussion/comment/315772#Comment_315772

Glad I could help. It can be easy to overthink things when working on formulas in Smartsheet! Many times simpler is better.