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

Automation
I am wanting to send a request for an update to our inventory control people when we have non-conforming material that needs to be contained in the system and physically. I have a column for each with a drop down of Yes, No,N/A. I have my automation setup for triggered when containment required changes to any value,…
Prepopulating Forms
I'd like to be able to enter a unique value in a form and have it prepopulate a few other areas of the form. For example, I'd like to enter an employee ID number in the FORM, and once entered the First and Last Name sections of the FORM would automatically populate with the correct information.
Record Approved By Email/Name
Hello- There's been a few question/discussions on this topic, but they are a but they are older posts. I'm trying to record the email/name and date when travel requests are approved. I'm capturing the approved date with a Record Date Automation, so that it easy, but the approved by field is getting messy. I'm currently…