nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

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?

Find more posts tagged with

Account and User Management

Comments

Mike Wilday

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?

JamesR

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

Sign in to join the conversation!

Quick Links

Trending discussions

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…