I have a slow sheet
Coleph01
✭
I have a smart sheet that has about 2400 rows with multiple sections this has been going since 2014 however it is running very slow. How can I fix this or can it be fixed?
Comments
-
Word on the street (in this community) is that lots of conditional formatting can have a severely negative impact on sheet performance. By any chance do you have a lot of conditional formatting?
-
Extract from Help Articles:
Sheet and File Size Limitations
Smartsheet has set size limits on both your sheets and the files you import to ensure you experience the best performance of our application.
Size limit for your sheets:
- Maximum rows: 5,000
- Maximum columns: 200
- Maximum cells: 200,000
Size limit when importing files:
- Max rows: 5,000
- Max columns: 200
====================
My Comments
Things that can impact on performance are:
- Conditional Formatting
- Nested Multi Parameter Formula
- Linked Cells
My Tips
- Archive data from previous years out to seperate sheet
- Create New sheet Each FY - If exactly the same as others then use report across all sheets to Interrogate data
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives