Children rows only for specific columns

Hi there,

I am currently trying to merge two sheets that have been created in my company. One has a list of projects/sales on it the other one has just the hardware for each project/sale. I had tried adding a new child row for each product under each project/sale to track quantities and production dates for each product. But this way I either end up having to copy the parent information into the children rows or I would end up with a whole lot of empty cells.

Is there a way to nest the products with quantities somehow ?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!