Counting RYG Balls

Jhay Fernandez

Hi guys,

 

Is it possible to count the number of balls according to their respective colors?

 

Many thanks in Advance.

ruiovaz

Hi

 

Try in a parent row:

=COUNT(CHILDREN() = "Red") for example

Hope it helps

 

Rui

 

Shaine Greenwood

Hi Jhay,

You'll need to use a COUNTIF formula for this:

=COUNTIF(CHILDREN(), "Yellow")

=COUNTIF(Status:Status, "Green")

More on formulas can be found in our Help Center: https://help.smartsheet.com/articles/775363-using-formulas#countif

John Creason

Hmmm....

Bet you couldn't get it to work with that equal sign in there  

=COUNTIF(CHILDREN(), "Yellow")

=COUNTIF(Status:Status, "Green")

Shaine Greenwood

Whoops, I was not thinking clearly when I typed this.

I've edited my previous comment; thanks John!

Peggy

I am still getting a unparseable error for this formula,

=COUNTIF({Range 4},"GREEN","YELLOW") {Range 1}, "EBS")

 

what am i missing?