How to link same type of multiple data on a single row from one Sheet to another.

Good morning,

I have two Smartsheets that I want to link and get some data.

Smartsheet 1 has the person's name (and some other info) and Smartsheet 2 has their certificate data. I'll add a Cert column on Smartsheet 1, to link the cert data from Smartsheet 2, however, some names have more than one certs. How can I link multiple certs in one row (Sheet 1) without repeating the person's name for each certificate?

I appreciate your time!

Find more posts tagged with

Accepted answers

Ramzi K

@Magdalini Finelli

If your goal is to show all certificates for a person in Sheet 1 from Sheet 2 in one cell in sheet one, you can use JOIN(COLLECT( ...

Example:

Sheet 1 with formula in Certificates column:

Sheet 2 with multiple certificates per person:

I hope this help you.

Cheers,

Ramzi

All comments

Andrée Starå

Hi @Magdalini Finelli

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Ramzi K

@Magdalini Finelli

If your goal is to show all certificates for a person in Sheet 1 from Sheet 2 in one cell in sheet one, you can use JOIN(COLLECT( ...

Example:

Sheet 1 with formula in Certificates column:

Sheet 2 with multiple certificates per person:

I hope this help you.

Cheers,

Ramzi

Magdalini Finelli

https://community.smartsheet.com/discussion/comment/265690#Comment_265690

Thank you very much! That helped! :)

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.