Linking multiple cells (with a caveat)

Ed Kinsch
Ed Kinsch ✭✭
edited 03/19/21 in Formulas and Functions

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.

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Answers

  • Danielle O'Connell
    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å
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • 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!

  • 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å
    Andrée Starå ✭✭✭✭✭✭

    @Ed Kinsch

    Excellent!

    You're more than welcome!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!