Can a one to many relationship be created in Smartsheets?

edited 12/09/19 in API & Developers
11/11/19 Edited 12/09/19

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

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


     

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.