How to identify child and sub-childs of a parent so I can add conditional formatting?
Hello, I have several sub-childs and I am trying to add a column where I can for example say if a cell is Parent return parent, if child return child and if sub-child return sub-child?
I looked into several resources but there isn't any easy answer. If you can please help.
Help Article Resources
Check out the Formula Handbook template!