Best Way to Pull A Ton of Data

John- Michael Diedrich

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.

Andrée Starå

Hi @John- Michael Diedrich

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!

John- Michael Diedrich

https://community.smartsheet.com/discussion/comment/367509#Comment_367509

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.