Welcome!

Frozen/Unresponsive Sheets

We're experiencing freezing/unresponsive sheets after a few moments of being open. This has been going on for a few days. Anyone else experiencing this?

Thanks

Find more posts tagged with

Sheets

Conditional Formatting

Cell linking

Comments

Shaine Greenwood

Hi Faith,

Slowness on your sheets can be due to a few factors:

Network—although other websites might work fine, there could be network conditions that interfere with Smartsheet. Temporarily try a different network to troubleshoot this.
Computer apps and browser extensions—certain extensions or computer applications can also interfere with Smartsheet. Try disabling all of your browser extensions; temporarily using another browser; and disabling any other applications that are running in the background to see if this improves performance. You might even temporarily try loading the same sheet on a different computer to see if there's a difference.
Outdated browser—make sure you're on the latest version of your browser, otherwise Smartsheet performance may be impacted.
Advanced functionality—if the sheets you're opening have any combination of hundreds of formulas or several complex formulas, dependencies, resource management, cell links or cross-sheet formulas, or a lot of people are constantly updating the sheets (through web forms, requests, or directly) then performance will be impacted. You may consider reducing formula usage or separating materials as needed onto multiple sheets.
Large sheets—another possible cause of slowness can be due to having large sheets (thousands of rows, dozens of columns) even if you're not using a lot of advanced functionality. Consider dividing your sheet into multiple logical volumes of separate sheets.

If you've tried the above and that doesn't work please reach out to our Support team to troubleshoot further.

detsad

We have the same problem

using sheets with 1000-2000 rows

Andrée Starå

Hi @detsad

I hope you're well and safe!

How advanced is the sheet? Advanced formulas/much conditional formatting?
How many columns?
Connections to and from other sheets?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Alina Ilina

Hello! And we have the same problem on different computers even in different cities and diff. users.

Only 1 formula - vlookup and about 850 rows: https://app.smartsheet.com/sheets/JFvRQ2Pmg3h7fXrvmVf7GW868XP7wMwJRJFqHXH1?view=grid

Andrée Starå

@Alina Ilina

I've requested access.

Alina Ilina

https://community.smartsheet.com/discussion/comment/307696#Comment_307696

accepted)

Carissa Coats

@Andrée Starå we are experiencing this issue as well, specifically in dashboards. Any advice?

Sign in to join the conversation!

Quick Links

Trending discussions

Issues Opening the Sheets
I'm receiving this message every time I try to open my sheets. I'm the only admin user. I have already performed proper troubleshooting, such as clearing the cache, logging in incognito, and logging out and back in, but the issue remains unresolved. It's been a few days, and I'm unable to track our projects and this…
Adding attachments to a generated document.
I’ve created an automation that generates a document and forwards it to the individual specified in a cell. The line item also has several additional attachments associated with it. Is there a way to include those attachments with the generated document?
How to copy row values and not formulas
I have an automation set up that copies a row to another sheet each day. The automation itself works correctly, but the problem is that it copies the formulas rather than the values, which causes the formulas to break and return errors. How can I configure it to copy only the values instead of the formulas?