Linking multiple cells (with a caveat)
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
-
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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
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!
-
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:andree@workbold.com | 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.
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | 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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!