Rows could not be added to the destination sheet because it did not have enough cells remaining

Ashish Solanki

Hi, Team, 

Could you please confirm why this workflow got this error while moving rows from source sheet to destination sheet as the destination sheet filled 4000 rows only yet.

Error - Rows could not be added to the destination sheet because it did not have enough cells remaining.

Paul Newcome

There is also a limit to the total number of cells used within a sheet that can potentially override the number of rows available. I believe that limit is 500,000. So if you have 125 columns, you will hit that cell limit once you have 4,000 rows.

Andrée Starå

Hi @Ashish Solanki

I hope you're well and safe!

You've reached the limit for the number of cells in the destination sheet.

Sheet maximums:

• Rows: 20,000
• Columns: 400
• Cells: 500,000
• Characters in a cell: 4,000

More info.

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

Did that work/help?

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 is also a limit to the total number of cells used within a sheet that can potentially override the number of rows available. I believe that limit is 500,000. So if you have 125 columns, you will hit that cell limit once you have 4,000 rows.

Sean Reilly

Hello - I am having the same issue. Something does not seem to make sense though. I am essentially trying to carve a subsection out of a larger sheet which has the room I need. Unsure how I can not have room in another sheet that would be less than the sheet I am trying to pull data from?