nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Count total of RYG balls

chris.italiano78351

Hi, can someone please help me - I am trying to count the total of Red, Yellow and Green Balls in a column and cant get my formula to work. Currently my formula reads

=COUNTIFS([Status2]4:[Status2]33, "GREEN", "YELLOW", "RED")

thank you

Find more posts tagged with

Comments

Paul Newcome

Very close! try something like this...

=COUNTIFS([Status2]4:[Status2]33, OR(@cell = "Red", @cell = "Yellow", @cell = "Green"))

Andrée Starå

Hi Chris,

Try this.

=COUNTIF([Status2]4:[Status2]33; "GREEN") + COUNTIF([Status2]4:[Status2]33; "YELLOW") + COUNTIF([Status2]4:[Status2]33; "RED")

The same version but with the below changes for your and others convenience.

=COUNTIF([Status2]4:[Status2]33, "GREEN") + COUNTIF([Status2]4:[Status2]33, "YELLOW") + COUNTIF([Status2]4:[Status2]33, "RED")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

chris.italiano78351

Thank You Paul, It worked - Much Appreciated!

chris.italiano78351

Thanks Andrea, appreciate the help - Tried Both you and Pauls, both worked. Thanks heaps

Paul Newcome

Happy to help.

Looks like Andree and I were typing up solutions at about the same time. Hahaha

Andrée Starå

Happy to help!

Best,

Andrée

Susie Wachowski

I want to do the same thing but I couldn't get the formulas to work. I'm in the States. Can you send me a formula suggestion for this:

Paul Newcome

@Susie Wachowski

My formula above should work for you. What exactly are you trying to accomplish and what results are you getting?

Susie Wachowski

I'm trying to count the number of green, yellow, and red balls in the Status column. I'm getting a #UNPARSEABLE error message. This is the formula I modified to count rows 3-142 in the Status column: =COUNTIFS([Status1]3:[Status1]142, OR(@cell = "Red", @cell = "Yellow", @cell = "Green"))

Paul Newcome

What is your actual column name?

Susie Wachowski

Status

Paul Newcome

Try using your actual column name instead of [Status1]. That should clear it up for you.

Susie Wachowski

Ahh yes, that was the secret, thank you!!

Paul Newcome

Happy to help! 👍️

Sign in to join the conversation!

Quick Links

Trending discussions

Data is missing
Hello, I created a Smartsheet Project yesterday (trial 30 day user). I input all relevant information including due dates, status, priority, etc. I returned from work just now and logged in to update something on the sheet and all info is missing. I can see the Project Folder but all rows are empty. I tried troubleshooting…
Can you do a portfolio report on manually created project sheets?
I have a portfolio with 1 project template. I created 2 projects from the project template. I realized I need a Project Metadata sheet to facilitate the portfolio reporting I need. So I added a Project Metadata sheet to the project template and manually to the 2 projects previous created from the template. I've confirmed…
Users incorrectly labelled as "External"
Hi Smartsheet users. We have a number of users who are being labelled in the "Seat types and true up" screen as "External". They all have the same email domain, which is different from the domain of users who are not flagged as External, however both domains belong to our company and are listed as verified under the…