Find Parent that is not blank or row with no children
How do I find whether a cell is a parent and not blank?
I have tried
=IF(AND(NOT(ISBLANK(Description@row)), COUNT(CHILDREN(Description@row)) > 0), 1, 0)
which gives me the parent and not blank, but it does not give me rows that do not have any children.
I need rows that are parents and not blank + rows that do not have children and are not blank
Appreciate your help
Help Article Resources
Check out the Formula Handbook template!