Problem saving smartsheet spreadsheet

Peterson

When I try to save any changes to the spreadsheet, it loads for a long time and then gives me the error:
formName: ajax
formAction: fa_gridSave
serverStatus: false
serverStatusText: CriticalException
errorCode: 48

brianschmidt

For this issue, I would recommend reaching out directly to Smartsheet Support: https://help.smartsheet.com/contact

In other instances where people have posted about this, resolution almost always seems to come about this way only.

Hope this helps!:)

Peterson

Many thanks for the reply! I opened a ticket with them yesterday and I'm waiting for the answer :)

Peterson

Today (18/06) I am able to save, but it takes time, around 30 - 60 seconds and the automations are too slow…

brianschmidt

https://community.smartsheet.com/discussion/comment/441253#Comment_441253

Yeah, that's real slow. Did support get back to you yet?

Peterson

They didn't give me any feedback, and I need this adjustment as soon as possible.

brianschmidt

Other than a technical glitch, I know sometimes there are issues with automations and loading speeds when there is a large volume of data in a given sheet. Unfortunately, there are max cell, row, etc. limits (see below).

If you are pushing the limits of any of the bounds shown above, I would recommend looking for ways to parse out data and sort it in separate sheets. Then, if you need to pull data together or see "focused" views of the data amongst sheets, you can do so with reports.

Peterson

https://community.smartsheet.com/discussion/comment/441278#Comment_441278

Thanks for the smartsheet limit data! I had thought about this possibility, but doing the calculations, it came out to 221,165 cells. I have 89 columns and 2485 rows. I'm working on a palliative solution to make the base cleaner, to stay away from the limits you mentioned above, once again, thanks for the help!