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.

Find more posts tagged with

Accepted answers

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.

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.