COUNTIF Parent but not Children
I added active to my child rows to get the children to appear on a report so now I need to change my formula to exclude children from a count because of overcounting. I have seen articles about helper columns and added a checkbox helper but I haven't had any success. Some answers have shown an IF statement, but where do I type that statement?
Best Answer

I use a helper column that tells you if a row is a parent or child. Using this formula,
=COUNT(ANCESTORS([Column Name]@row)) ,
the helper column would have a value of 0 for SRS (parent) while Read Only, Planning, etc. (child rows) would have 1. Of course, you would then change to COUNTIFS to account for the additional variable.
Will this work?
Answers

I use a helper column that tells you if a row is a parent or child. Using this formula,
=COUNT(ANCESTORS([Column Name]@row)) ,
the helper column would have a value of 0 for SRS (parent) while Read Only, Planning, etc. (child rows) would have 1. Of course, you would then change to COUNTIFS to account for the additional variable.
Will this work?

That worked. Thanks for the help.
Help Article Resources
Categories
Check out the Formula Handbook template!