Count, Children, Status

Hello, I wanted to create a report/dashboard that showed the total number of items under a parent and how many of those items were in a non-green status. I am entering my formulas on the Sheet Summary section.

I have created the formula for count of children but am having a hard time showing count of those children with non-green status. Can anyone point me in right direction?

Answers

  • Hi @Maureen Barger

    Are you looking for a count below one specific Parent row, or just Child Rows in general throughout the whole sheet?

    It sounds like this formula would actually be better placed within the grid of the sheet instead of in a Sheet Summary section. This way the grid can return results per-parent row and then you can use the Summary fields to either SUM that together, or create averages, etc.

    This is how you would build a COUNTIF formula in a Helper Column in the sheet:

    =COUNTIF(CHILDREN(Status@row), <> "Green")

    You'll notice I put the the COUNT of all Children in the Status column as well. This is just

    =COUNT(CHILDREN())

    Then the Helper Column houses the formula to see what is not Green.

    Let me know if this works for you!

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!