Can a one to many relationship be created in Smartsheets?
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.
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
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 for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I have the same question : I've attached a sample of what I need.
-
Here is a way to do something similar for Pam's sample.
https://app.smartsheet.com/b/publish?EQBCT=8e917db42c094d89a8f467fb76e05d1a