Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Can smartsheet do this
I'm new here but have watched multiple webinars and read the getting started info. Before I invest a lot of time in this, I'm wondering if smartsheet has the ability to link two sheets with a one-to-many relationship. For my purposes, I'd like to have one sheet of open orders and another sheet of lineitems. There can be multiple lines per order but each line can be on only one order. I've seen the "link" ability but I'm not sure it's intended for this and I would love for the "order" sheet to be updated as individual lines are completed. For instance, I work for a company that makes jewelry. If we get order 001 that has 3 lineitems (001-1, 001-2, 001-3) and each lineitem is assigned to be made by a different employee. As each employee completes their assigned lineitem, they flag the lineitem as complete. Once all lines are complete, could smartsheet update the order itself to complete so we know to ship it? Any recommendations for structuring this? Would each order be like a project, or would another method be better? Thanks for your help.