I need help figuring out how to count the number of children rows that have a certain status.

Daniel Montoya

I can't seem to figure out how to get this formula to count only the children rows that have a certain status.

For example:

I want to get a count of the status of Green, Yellow, and Red of only the children rows of Parent row SWAR Caribbean Distributors in the column Dealer Legal Name. The children of the parent row SWAR Caribbean Distributors are also parents rows themselves with Children rows under them.

I only want to count the status of the Children row of SWAR Caribbean Distributors.

Does anyone know if this is possible?

Thanks

L_123

I believe you need a helper column in order to do this task.

=if(count(children()),1,0)

would go in the helper column, then you can just use an ordinary countifs using the helper column as one of your criteria.

Daniel Montoya

@L@123 Is there any way we can do a call or to share screens to show you what I need?

L_123

Sorry, i'm heading out of the office now. You can check out this sheet that should give you enough hints to be able to build what you need.

https://app.smartsheet.com/b/publish?EQBCT=4b21df207d1847ab914e9a2f9465ee24

Image below for if I delete this sheet sometime in the future.