Usability Problems on Big Sheet

Gerardo_Clarke

HELLO

I HAVE AN USABILITY PROBLEM

CURRENTLY OUR MAIN SHEET (ADMIN_2021) IS ONLY USING 41% OF CAPACITY, ACCORDING TO THE REPORTS OF EACH SHEET. INFACT WE HAVE 204.000 ACTIVE CELLS TO DATE (CURRENTLY USING 51 COLUMNS AND 4000 ROWS )

I AM THE OWNER OF THE SHEET, WITH A TOTAL OF 3 ADMINISTRATORS, 4 EDITORS, AND 2 OBSERVERS. USUALLY THERE ARE 7 USERS ON LINE USING THE SHEETS.

SINCE ABOUT A WEEK AGO WE HAVE HAD SERIOUS USABILITY ISSUES, WHICH HAS MADE WORKING WITH THE SHEETS VERY SLOW AND TEDIOUS. WE STILL HAVE 3 MONTHS LEFT TO THE END OF THE YEAR WITH THIS SHEET.

WE USE THE SHEET ¨PER YEAR¨ FOR WHICH WE PROJECT A USE OF ABOUT 70% OFTHIS RESOURCE.

THE MAIN PROBLEM IS RELATED TO THE ¨SAVE AND SYNC¨ RESPONSE WHEN UPDATING WHICH LOOPS REPEATEDLY A DISPLAYS WITH NOTIFICATION "10 minutes have passed since you last saved changes.". SOMETIMES IT¨S RELEASED

ANOTHER ANNOYING CHANGE IS WHEN SAVING, DESPITE NOT HAVING EFFECTED ANY MODIFICTIONS, IT NOW DISPLAYS REQUEST TO SAVE AND UPDATE. THIS WAS NOT HAPPENING BEFORE, EVEN WHEN ANOTHER USER MADE MODIFICATIONS, IT WOULD ONLY BE REQUIRED TO UPDATE.

I HAVE BEEN CHECKING THE SERVICE STATUS PAGE, AND ALTHOUGH EVERYTHING APPEARS OPERATIONAL WE CONTINUE HAVING THESE USABILITY ISSUES. 

I THANK THE HELP THAT YOU CAN GIVE US TO SOLVE THIS PROBLEM.

BEST REGARDS,  

Paul Newcome

Formulas, cell links/cross sheet references, automations, and conditional formatting all also play a role in sheet speed.

Gerardo_Clarke

Paul Newcome, thanks for your response, Indeed, the sheet in question has everything you indicate, but ... what are the limits? of links, automations, information crossing between sheets, reports, etc. I am not clear about it.

Andrée Starå

Hi @Gerardo_Clarke

I hope you're well and safe!

To add to Paul's excellent advice/answer.

More info.

https://help.smartsheet.com/articles/506775-system-requirements-for-using-smartsheet

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!

Paul Newcome

There are limits to links/cross sheet references, but really it may not be so much that you are approaching any one limit but that you are using a lot of combined resources.

My suggestion would be to first see if you can get rid of or combine any conditional formatting and automations and see if you can simplify formulas or look for redundancies that could potentially be removed.

Andrée Starå

@Gerardo_Clarke

Have you also made sure that you're using the most efficient formula structure, like @row, @cell, and column formulas?

I'd be happy to take a quick look.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Gerardo_Clarke

@Andrée Starå I am making a copy to share the sheet.

Indeed, I have many cross-leaf references, automations, panels, etc.

But as I see that I have not yet reached 43% of use, it seems strange that it becomes so tedious and annoying.

Gerardo_Clarke

@Andrée Starå Ready, shared with you. Thank you very much.

Gerardo_Clarke

Hi @Andrée Starå ,

I have to tell you that I made the claim directly to Smartsheet customer service the same day I posted this case. And after about 24 hours everything flows again as before.

They have not answered me anything formally, but these days he has behaved as he should be. I would love for you to send me an explanation of what was happening and how they solved it.

If you answer me, I promise to share with you in this thread.

Grateful for your help.