How to create a master sheet that can work-around the 20,000 row limit?
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!
Answers
-
Have you looked into the Premium App, Data Table? https://www.smartsheet.com/marketplace/premium-apps/datatable
-
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!
-
@Justin Pickering maybe we have some solution .
If my comment helps you, I appreciate a 💡
Kind regards
Meet me at Engage in Seattle !
Nico | LinkedIn
CEO | Lighthouse Consultings
addvalue@lighthouseconsultings.com
We offer Licenses - Training - Solution Engineering
🔴Certified Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!