Join Function using parent child


Since reports do not carry the parent / child structure, I need to create a helper column on a sheet.

I need to create summary reports for each child, but in that report I need to show the Parent name.

For example. I need an Assembly report that shows me the Parent dates of the Assembly. See the images below. Right now I can only get it to say Assembly but need to show Messerschmidt, Abelson Office, etc


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!