Is there a way to automatically add two sheets data into one new sheets as parents and childrens row



I was wondering is there a way to bring two smartsheets data into one automatically. Smartsheet A datas will be the parent row in Smartsheet C, and Smartsheet B will match the smartsheet A data and automatically added into Smartsheet C as children row.

I did a lot of research and it seems like it's not possible.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!