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


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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!