How to create a master sheet that can work-around the 20,000 row limit?

Justin Pickering

Hello Everyone!
I need to consolidate data from two large Smartsheet sheets into one master sheet to use as a reference for another sheet. However, Smartsheet's 20,000-row limit prevents me from combining everything into a single sheet.

I cannot use Smartsheet Reports as a workaround since reports do not support formulas, which are essential for my project. I'm looking for alternative solutions that allow me to consolidate the data while maintaining the ability to use formulas in the reference sheet.

Some advise or ideas would be greatly appreciated!

Heather_Verde

Have you looked into the Premium App, Data Table? https://www.smartsheet.com/marketplace/premium-apps/datatable

Justin Pickering

Ahh It never occurred to me that there was an Premium option, that being said I was hoping there would be a non-premium alternative we can work with!