I have made a sheet to collect some important information in a sheet and i have got a message that I have reached cell limit of 200,000 for this sheet, So I would like to ask if Is it possible to increase the limitation in this sheet?
Hi @Mohammed Alolayan,
Smartsheet recently increased the sheet size limit from 5,000 rows to 20,000 rows. For sheets approaching this size, we recommend taking a look at ways you can move completed items to another sheet, split up data into different time frames or other logical groupings.
When you have a moment, please submit a Product Enhancement Request to let our Product team know that you'd like to create sheets larger than 20,000 rows.
Hi @Mohammed Alolayan,
The new cell limit is 500,000 so you shouldn't have an issue. (see below)
If you're still having issues and if you haven’t already, I would recommend that you reach out to the Smartsheet Support Team.
Available on all plan types, sheets now support up to 20,000 rows, 400 columns, 500,000 cells, 100,000 cross-sheet cell references, and 20,000 cell links. In addition, users will see up to 2x faster load times and up to 6x faster sheet scrolling.
I hope that helps!
Be safe and have a fantastic weekend!
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
I actually reached the 400 column limit on my database. I can't split up the sheets because almost all the columns are required to generate fairly large, but standardized documents with. I need about 80 more columns, I guess until they change the max column limit I have to use a workaround of having a few different document templates prepopulated with the data I can do that with, this helps eliminate about 80 columns for me, but then I need 6 different document mappings instead of one.
I hope you're well and safe!
Expanding the number of columns is a great idea! That would be a great addition to Smartsheet features.
Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.
Be safe, and have a fantastic weekend!
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
I'm considering using it in this same fashion. i.e. to create large documents with more than 400 fields. how many pages are your document? I'll need to go through some of my documents and count the number of fields I might need. Some of the documents are inspection documents about 80 pages long where the inspector has to complete the form / document. I suspect Smartsheet isn't the tool for that job but it is an interesting thought. Microsoft forms/FSM, device magic, fastfield, nintex, etc and others are more built for this kind of thing. Smartsheet is close to having everything needed though so it is a bit frustrating when we are paying for it already.
Did you ever come up with any way forward for your situation?
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.