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

Ivan Borisov
edited 12/09/19 in Archived 2016 Posts

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
    J. Craig Williams ✭✭✭✭✭✭

    Something like:


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


    in the parent row?



  • 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
    Travis Employee

    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:




    "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! 

This discussion has been closed.