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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!