Is there a way to have a parent row and child row live in two separate sheets?

Options

I am looking for a way to have a parent row and child row live in two separate sheets. I am trying to avoid (at all costs) having two unrelated rows in different sheets with product data for the same company.

Here's some additional context to help with understanding of my need:

I am using Smartsheet to track product validation testing for my team's partners. Normally (90% of the time), a partner comes into the lab validation testing with one product. Once in a while a partner will come back in the future with a new product that they additionally want tested in our lab. I need to be able to track and document these two products in separate sheets but keep them related to the partner itself.

Ideally, I would have the partner as the Parent row and the products as the Child rows. The problem is that, although the product testing is for the same partner, the individual products may get assigned to different members on my team for testing and, therefore, would be tracked on their separate pipeline sheets.

Hoping someone has a solution, or work around that will help!

Answers