How to count different status from one column

Ivan Borisov

Dear all!

In our projects we use smartsheet as data base for elements of decor. At the moment we have four different statuses on each elements. In this case would like automatically count all red, blue, yellow and green statuses and see how many elements we have on different production  stage.

 

I know how to coun all children rows  by the formula SUM(CHILDREN()), in this case we can see total amount of element incide specific groups but we also would like to understand how many parts with different status are there. It would be grate to see it  with same principe how the folrmula SUM(CHILDREN()) works.

 

 

Any ideas how we can count our elements? 

 

J. Craig Williams

Something like:

 

="N_0001: (" + COUNT(CHILDREN()) + ")"

 

in the parent row?

 

Craig

Ivan Borisov

I'm sorry but I think my explanation of the issue was not so good because of my english.

 

I'll give an example:

we have parrent row named "N"

This row has some children rows called N_0001, N_0002, N_0003 etc. 

Each row N_0001, N_0002 etc. has different status: red, green....

 

So I need to count in the parrent row haw many red, greeen, yello, blue statuses I have in childrens. 

 

Hope now it's better))

Travis

Hi Ivan, this formula can be added to a parent row RYG cell and will count the number of times a status ball appears in the child rows:

 

=COUNTIF(CHILDREN(), "Red")

 

"Red" can be replaced with Yellow or Green.

 

Do you want to count each type in the same cell? Try this:

 

=COUNTIF(CHILDREN(), "Red") + ":R " + COUNTIF(CHILDREN(), "Yellow") + ":Y " + COUNTIF(CHILDREN(), "Green") + ":G"

 

This will come out as:

 

2:R 3:Y 1:G

 

The text can be changed based on how you want it displayed. 

Ivan Borisov

Dear Travis! Thank you so much for the solution! It works as I wish!