Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How to count different status from one column
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?
Comments
-
Something like:
="N_0001: (" + COUNT(CHILDREN()) + ")"
in the parent row?
Craig
-
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))
-
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.
-
Dear Travis! Thank you so much for the solution! It works as I wish!
