Can I create one:many and many:many relationships between two SmartSheets?

Hello,

I have two related SmartSheets covering different aspects of my data. I would like them to refer to each other so that I can ultimately pull certain aspects into a report. I prefer to use SmartSheet over SQL in order to take advantage of the workflow and approval capabilities.

However. I cannot figure out how to link data in the case of one:many and many:many relationships. See the example below (yellow is my desired result; blue are already linked since they are 1:1 relationships. Does anyone know if this is possible and if so, how to accomplish it?

Thanks in advance!

Find more posts tagged with

Sheets

Solution Center

Cell linking

Accepted answers

Etienne Mermillod

Hi,

Have you already defined wich sheet will the the one storing the raw data, if not please define one (could be another sheet).

On that sheet try to have only single selection drop down/contact list to make things easier.

Then, create formula on the 2 sheets above to collect data from your store sheet.

Note, in SQL the best way to stopre N-N relationships is by using a table in between, but as in smartsheet dumping data into one big large sheet, with possible duplicates is a better option on most cases.

All comments

Etienne Mermillod

Hi,

Have you already defined wich sheet will the the one storing the raw data, if not please define one (could be another sheet).

On that sheet try to have only single selection drop down/contact list to make things easier.

Then, create formula on the 2 sheets above to collect data from your store sheet.

cjul001

I'll try creating a flat file and see how that works. Many thanks!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.