Large Data Set Solution
Hello,
I have created a table to view weekly data displaying how many cases are worked vs hours worked. This table is using several SUMIFS fuctions to pull from 3 separate source sheets.
My issue is these source sheets are updated every 2 weeks with roughly 2,500 rows each. So far, I have only done weeks 3-6, skipping the first 2 weeks this year, and my largest sheet is at 8048 rows. With the 10,000 row limit in two weeks I will likely exceed the limit. I need all weeks to be accessible for all 52 weeks of the year. I thought to use DataTable but I can't link to it with SUMIFS and to create individual sheets for each week is combersome and not ideal. I also want to utilize DataShuttle to help pull the data in automatically.
END GOAL: To be able to have this whole report run automatically without losing data from the previous weeks in the process
FOR BONUS POINTS: Any idea how to have DataShuttle look at different tabs in an Excel file? It seems to default to the first tab, do I need to create three separate files?
Best Answer
-
Hi,
As I understand you are using the SmartSheet sheets as source data. You only one it all in one place so you can work with it. My suggestion is to use Report where you will collate all the data and you can work with it without any limitations.
If you need any calculations done above the data you can create "helper" column in each sheet and then you'll use Group and Summarize feature of the report to get the data you need.
Will this work for you?
Best,
Beata
Answers
-
I'm thinking maybe there is a way to snapshot all the data auatomatically each move so that it can clear the source sheets and only import the new data maybe? Is this do-able?
-
Hi,
As I understand you are using the SmartSheet sheets as source data. You only one it all in one place so you can work with it. My suggestion is to use Report where you will collate all the data and you can work with it without any limitations.
If you need any calculations done above the data you can create "helper" column in each sheet and then you'll use Group and Summarize feature of the report to get the data you need.
Will this work for you?
Best,
Beata
-
I'm using reports but the issue is the complexity of the data in the Activity report I've made and the large sums of incoming data bi-weekly.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!