If you’re experiencing issues with a specific sheet not loading or saving as expected, Smartsheet may be timing out because it’s processing significant amounts of data.
This behavior most commonly occurs in the following situations:
- The sheet is approaching Smartsheet size limits.
- The sheet is leveraging a significant number of advanced capabilities such as conditional formatting, complex formulas (especially cross-sheet formulas), predecessors, or multiple inbound cell links.
The following sections of this article include tips about how to optimize your sheets for faster load time. For specific maximums and recommendations about best practices for advanced capabilities, see System Requirements and Guidelines for Using Smartsheet.
Reduce the sheet size
The larger a sheet is, the more processing power it takes for your browser to load and save the changes. Here are some ways to reduce sheet size:
- Delete or move rows to another sheet.
You can use automation to move rows automatically based on specific criteria that you specify (more information on that here).
- Break up the sheet into logical divisions, such as by month, and then use a row report to consolidate rows from the different sheets as needed.
For more information about how to build a report, see Build a Row Report with Report Builder.
Break a large project into smaller ones
In a project sheet with a large number of predecessors and dependencies, any change will cause all of the tasks in the sheet to adjust—which may slow sheet performance. To remedy this, consider breaking the project into subprojects, each in its own sheet. Once you’ve broken the project into subprojects, you can use a row report to consolidate rows from the different sheets as needed.
Reduce the complexity of the sheet
Reducing complexity doesn’t mean that a sheet will be less useful or powerful. Follow the best practices here to maintain functionality and improve efficiency: