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

How to incorporate a hyperlink to a SharePoint file in Approval automation
Need help: We are using an approval request automation where we would like to incorporate a SharePoint link rather than a file attachment to the request. We have a sheet column with the hyperlink, but it does not show up in the approval email or it shows up as a LONG URL. Needs to function both from desktop computer as…
Guest User with Admin Permissions is unable to edit a Dashboard
I am the owner of a workspace that has multiple sheets and a dashboard. There are 3 Guests with Admin permissions for the whole workspace. They can edit the sheets, but not the dashboard. Is there a different type of permissions or some kind of limitations to dashboard editing for Guests?
Raffle Type System in a Smartsheet Form
I am looking at trying to build a multi-select option raffle form. Lets say a form user has 5 options or "tickets" they can put into a bucket of goods for a raffle. I would like for the user to put in any combination of entering tickets per good that they can with the five tickets they have. I will put in a picture of what…