Cell Limit Issue

KristinaMiteva

I have the above sheet which as approx. 277,000 cells. I attempted to set up an automation from another sheet to add missing work orders to this one and it says:

please help

Jeff Reisman

https://community.smartsheet.com/discussion/comment/315226#Comment_315226

The main limits are: 500,000 cells, OR 400 columns, OR 20,000 rows.

(Other limits include things like 100,000 unique cell links in cross sheet formulas. For example, if I'm performing lookups against columns in another sheet with 9,000 rows, I can have only 10 or maybe 11 columns bringing data in from that sheet.)

Andrée Starå

Hi @KristinaMiteva

I hope you're well and safe!

You've reached one of the limits, so you'll need to delete rows/columns to get below the limit again.

Make sense?

I hope that helps!

Have a fantastic week & 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 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!

KristinaMiteva

I read that the cell limit is 500,000 cells. My spreadsheet has approximately 277,000.

Andrée Starå

@KristinaMiteva

There are other limits as well. Could it be that you've reached one of them?

More info:

https://help.smartsheet.com/articles/506775-system-requirements-for-using-smartsheet#toc-sheet-and-imported-file-size-maximums

✅Remember! 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!

Jeff Reisman

https://community.smartsheet.com/discussion/comment/315226#Comment_315226

The main limits are: 500,000 cells, OR 400 columns, OR 20,000 rows.

(Other limits include things like 100,000 unique cell links in cross sheet formulas. For example, if I'm performing lookups against columns in another sheet with 9,000 rows, I can have only 10 or maybe 11 columns bringing data in from that sheet.)

KristinaMiteva

Ok, thank you!

KristinaMiteva