Out of Memory Error

Kiat Umporn

I was trying to edit a formula in a cell for just one row which worked as usual. But once I converted it to a column formula it just stopped. When I tried to hit the save icon the web page show 'Error Code: out of Memory'. My sheet being edited has approx 4500 rows. This is the first time I encountered this problem. Need help.

Bassam Khalil

Hi @Kiat Umporn 

Hope you are fine, please check the following article to check if you in the sheet limit for rows and columns and cells

https://help.smartsheet.com/articles/2478811-scc-requirements-guidelines

Andrée Starå

Hi @Kiat Umporn

How much memory do you have on your computer?

Is the formula advanced?

If it's not solved, and if you haven’t already, I would recommend that you reach out to the Smartsheet Support Team.

I hope that helps!

Have a fantastic day & Happy New Year!

Best,

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

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

Kiat Umporn

Hi @Andrée Starå and @Bassam.M Khalil

Thanks for your reply.

My computer has 8GB RAM. The sheet has 4,500 rows x 45 columns, so it is much smaller than max 20,000 rows x 400 columns. And the formula looks like this:

=if(sumifs(duration:duration,technician:technician,technician@row,date:date,date@row,starttime:starttime,>=510,finishtime:finishtime,<=1050)<=480,"Green","Red")

As I said, one row is OK, but it crashed when converted to column formula. I did tried on both Chrome browser and Edge, they yield the same result.

Will try to contact the support team.

Thanks again.

Kiat Umporn

Andrée Starå

@Kiat Umporn

Happy to help!

There is also a limit of 500 000 cells, but you've not exceeded that limit, so that is not why.

The only thing I can think of for the issues is that you activate the column formula for so many rows at one time.

Let me know what support says.

markkrebs

I had the same issue and someone else I know had the same issue. My guess is its a hidden platform bug and not an up against references or sheet limits issue. Kiat - did Support give you any solution? @Genevieve P. - any advice / history with this issue?