# Form Summary Sheet

Options

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.

• ✭✭✭✭✭✭
Options

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

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭✭✭
Options

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

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭✭✭
Options

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

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• Options

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

• ✭✭✭✭✭✭
Options

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

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!