Formula to count # of certain status symbol

Hello,

I have created a column/dropdown with Symbols Green, Red, Yellow, Gray. I'd like to count the number of cells that have Green status in Status column. (in other words, count the # of Green(s) symbol.

In searching Smartsheet community, I saw a reply from 2017 regarding a similar question. The suggestion was to use the following formula:

=COUNTIF([your data range], "Green")

So I used: =COUNTIF([Status:Status], "Green"), but it doesn't work. I get #UNPARSEABLE.

What formula to use to get this count?

Thanks,

Tali

Find more posts tagged with

Accepted answers

Peggy Parchert

Hello @TaliRXM

Try =COUNTIF(Status@row, "Green")

Or are you trying to do this from Sheet Summary? If you are using Sheet Summary, try this:

=COUNTIF(Status:Status, "Green")

Hope this help!

Peggy

All comments

Peggy Parchert

Hello @TaliRXM

Try =COUNTIF(Status@row, "Green")

Or are you trying to do this from Sheet Summary? If you are using Sheet Summary, try this:

=COUNTIF(Status:Status, "Green")

Hope this help!

Peggy

TaliRXM

Hi Peggy,

Yes, I was trying to do this from 'Sheet Summary' and now the 2nd formula above =COUNTIF(Status:Status, "Green"), worked. I see that I had the brackets positioned wrong.

Just for my knowledge, the first formula =COUNTIF(Status@row, "Green") will work if I do it in the sheet itself?

Thanks much for your fast reply and help!

Tali

Peggy Parchert

@TaliRXM

Wonderful! Yes - the first formula would work if it was in a column in the sheet itself.

Happy to help!

Peggy

TaliRXM

THANK YOU!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.