Can a one to many relationship be created in Smartsheets?

Can a one to many relationship be created in Smartsheets?

edited 12/09/19 in API & Developers

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?

Comments

  • 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å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

    work-bold


     

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.