Can a one to many relationship be created in Smartsheets?

Dean Sund

For example I have sheet A that has my master list and all components within a "Kit".  On sheet B I have multiple kits and would like to reference all the included components.  I get that you can link cell to another just like and spreadsheet, but is there a way to link the value?

PPS Solutions

Hi Dean, do you need the components for the kits to be listed in a Smartsheet or would a report suffice?   I don't believe there is a way to perform one-to-many reporting within Smartsheet but you can do it outside Smartsheet via reporting tools eg Power BI.We did this recently and it worked well.

Andrée Starå

Hi Dean,

I created a similar solution for a client recently. I'd need more information to know if it would work in your use case.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

 

Pam Parrish

I have the same question : I've attached a sample of what I need.

Lookup Sample.xlsx

Update Sheet.xlsx

jmyzk_cloudsmart_jp

Here is a way to do something similar for Pam's sample.

https://app.smartsheet.com/b/publish?EQBCT=8e917db42c094d89a8f467fb76e05d1a