Sheet Row Limit - Automation Recos / Suggestions

Mike Rini

With one of our clients, we are running into the 20,000 sheet row limit, and I was wondering what others have done to work around this issue?

My first instinct is to createduplicate a sheets, and then use a report to pull it altogether in the end. It's a pretty manual solution, so I'm looking for something more automated

@Andrée Starå any suggestions on how to best approach running into this issue?

Ryan Sides

Hey @Mike Rini it depends on your particulars, but:

1) Archive any rows (use the Move rows automation to move them to another sheet)

2) Subdivide your data by some means (State, department, employee, etc.) and create multiple sheets. You can automate any row movements to other sheets for future row additions too.

3) Use Data Table to work with larger data sets.

Hope that helps.

Mike Rini

Thanks, @Ryan Sides.

• Definitely onboard with the archiving approach - we just haven't hit that yet (which is another problem)
• Yeah, I'm trying to figure out where we can create more of a normalized database (or sheet) structure to limit the rows, but wasn't sure if that was the only / best solution
• Regarding Data Table - I've never used that, and did a little digging on that. Is that something that would appear in Launcher area where DataMesh, DataShuttle, etc. are? I can't figure out where it would be, and am wondering if we have access - we do have an Enterprise license so I'd think we would.

Ryan Sides

@Mike Rini You should have a "Connections" menu in your sheets if you have it...

Andrée Starå

Hi @Mike Rini

I hope you're well and safe!

DataTable, Data Shuttle, and DataMesh are Premium Apps, and it's not included in the Enterprise license.

I agree with Ryan as to what options you have.

I hope that helps!

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!

Mike Rini

Thanks all! Looks like we have 2 out of the 3, but not the one I need to leverage for this particular challenge

Andrée Starå

@Mike Rini

Happy to help!

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!

Ryan Sides

@Mike Rini no worries Mike. Reach out if you need anything. -Ryan