10000 cell (combined) reference limit
Community,
I'm getting the "10000 cell (combined) reference limit" in a grid file and cannot overcome it. My situation:
- I have 5 master files with approx 14,000 lines of data
- using =count to simply pull the number of lines in each file and summing those for a total using a single range in one column in each of the 5 files
That works fine until I try pulling in more metrics doing the following:
- I do =countifs to find out how many lines are in "complete" status by looking in a status column for each file...then I get the limit issue.
How else can I extract my data from 65k lines to get the metrics I need for my team?
Thank you for any help on this issue.
Brad
Answers
-
Depending on the metrics you need, you can create a report, group by status, then insert a Count summary field in the report.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you @Paul Newcome!
I'm trying to pull metrics into a sheet to feed the dashboard. I'm not sure using a report will work to be able to feed charts and graphs and numerical widgets on the dash. Or can your proposed method achieve that?
Thanks!
Brad
-
It possibly could. Really it depends on exactly what kind of breakdowns you need. You would set the filters up based on the range/criteria sets, group by the primary data point, then use a Summary to count/sum/avg.
Lets say you want to count how many statuses are "Closed" by Assigned To. You would set the report filter to only show rows that are closed, group by assigned to, then apply a summary to the status column to "count". You would then reference this report in your chart widget.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 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