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

Magdalini Finelli · 10/12/20

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!

Ramzi K · 10/12/20

@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

Andrée Starå · 10/12/20

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!