Best Way to Pull A Ton of Data
Hello Community,
I have recently been given the challenge of pulling a ton of data from a source sheet to a target sheet, and am trying to figure out the best way to pull all the data efficiently and not run out of space too quick. Unfortunately we cannot use data mesh because each row has 7 target columns to pull from.
Our source sheet has all of the data stored, and the target sheet is where we are trying to pull a ton of data. I say a ton of data because we are pulling 11 columns per resource, and there are 7 resources per row, so we are pulling a total of 77 columns per row (a ton of data).
I had it setup as a VLOOKUP but once I found out how much data is involved I switched to an INDEX MATCH formula. I am concerned about running out of space quick so this is why I am asking for help, as well as if there is a better/more efficient way to move the data.
Any help here is greatly appreciated! I am happy to answer any questions.
Answers
-
I hope you're well and safe!
Can you elaborate? When and how should the data be added?
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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. 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.
-
Hey Andree, thank you for reaching out.
We just need to pull the data from the source sheet to the target sheet in an efficient way that will not break in the future because of how much data needs to be pulled. I am open to any ideas you have! The sheet does not have to update immediately, although that is preferred.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!