Can a one to many relationship be created in Smartsheets?

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?

Find more posts tagged with

API and Developers

IT & Operations

Product Development

Account and User Management

Comments

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, andree@getdone.se)

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

Sign in to join the conversation!

Quick Links

Trending discussions

Using Control Center to Track Folder Updates?
Hello, I am unsure of the feasibility of this goal but am hoping someone could provide some insight. Within my organization we have the following structure Workspace → Workspace → Folder. Within this folder we have additional folders that are added through an API integration we have setup. I am hoping we would be able to…
Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
Were there recent changes to the totalPages parameter when querying the /sheets endpoint?
Up until last week, the totalPages and totalCount parameters functioned as expected when performing a simple GET call to /sheets. If there were 150 sheets, then it would show "totalPages": 2, "totalCount": 150. As of Friday of last week, it seems like it is showing "totalPages": 1, "totalCount": 100 any time there are more…