Linking multiple cells (with a caveat)

Ed Kinsch

Hello Smartsheet Community! I'm trying to link multiple cells at once from the source sheet (the information is in cells across one row. They are not necessarily contiguous, but I could make it that way if necessary, which my example will show, but I would prefer not to do it that way.). To link them into my destination sheet, I need the information to be listed in a column instead of a row (Column B). I know I can link each individual cell separately. Indeed, that is a fix, but it is not time efficient. So, does anyone know how to do this using or not using a contiguous range in the source sheet? Thanks in advance for your help.

Source Sheet:

Destination Sheet:

EDIT: Realized I posted this in the wrong forum. Will re-post appropriately.

Andrée Starå

Hi @Ed Kinsch

I hope you're well and safe!

You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.

Another option could be to create a section in the Source sheet that looks like the destination, link the cells in the source sheet to the new section, and then use it to cell-link to the destination.

Would any of those options work/help?

I hope that helps!

Be safe and have a fantastic weekend!

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!

Danielle O'Connell

I haven't found a faster way to do it other than link each cell individually. If anyone else has a workaround I love to to hear it too!

Andrée Starå

Hi @Ed Kinsch

I hope you're well and safe!

You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.

Another option could be to create a section in the Source sheet that looks like the destination, link the cells in the source sheet to the new section, and then use it to cell-link to the destination.

Would any of those options work/help?

I hope that helps!

Be safe and have a fantastic weekend!

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!

Ed Kinsch

Hi @Andrée Starå,

Thank you for the suggestions. I'm not certain they would work in my case, unless I'm not properly visualizing how I could use VLOOKUP or INDEX/MATCH. Ultimately, customers fill out a form which will generate customer information and product quantity/dollar amount. Once received, we calculate what their discount should be and enter it in that same sheet. Lastly, I created a template with the information that needs to be sent back to the customer. Think of this as a receipt but with the discount information included. This information needs to be presented vertically, in two columns, so the information can be sent to the customer in a one page pdf.

Any other suggestions or advice? Or, am I just missing how I could get VLOOKUP to work? I am all ears, or in this case, eyes. Thank you!

Ed Kinsch

Hi @Andrée Starå,

A second cup of coffee this morning and revisiting your VLOOKUP suggestion did the trick!

Thanks again for your assistance.

Andrée Starå

@Ed Kinsch

Excellent!

You're more than welcome!