Increase sheet row and column limits

GwenM · 01/02/24

Definitely looking forward to the increases announced & coming in 2024. There are some key use cases that we have that will benefit from this. Any update on timing Smartsheet team?

Adam Murphy · 01/09/24

Can we PLEASE have some visibility into timing aside from "2024"? Even incremental updates in capacity would be very welcome at this point. These limits are causing internal teams to look to other solutions, so we really need to understand realistic timeline to when smartsheet will be feasible to use with enterprise quantities of data.

Also having to split sheets is a horrible workaround that cause exponentially more work and then still butts up against the cross-sheet references/cell-link limitations.

Until these new limits are available, Smartsheet cannot be seen as an Enterprise solution, unfortunately.

Adam Murphy · 01/22/24

@Riaan Kotze (or anyone from Smartsheet) Can we please have an update on this?

kcollins · 02/01/24

@Bob Fraser is there any update on timeline for this?

danabryant · 02/08/24

I have a business use case right now that would involve the need for 100k+ rows. Has there been any updates on the timeline for expansion?

Riaan Kotze · 02/12/24

@Bob Fraser , Good day,

Please do give feedback on this matter. You have given an outline of your plan March 2023. Is there any progress in this update?

Sherry Fox · 02/12/24

With my projects 20K does not take long to reach, and we don't tend to Achieve rows of a project, as we want our dashboards to include the historical data too.

Peter Tyrrell · 02/16/24

My firm is in exactly the same boat. We've had to port some of our stuff BACK to Office 365. I do wish Smartsheets would at LEAST give us a time line so we can make more informed decisions. 500,000 cells and 20K rows has become problematic.

BFoster · 03/01/24

I'm trying to move my department into smartsheet and we've hit the 400 column limit already without having even moved in fully. This has slowed down our onboarding. Whenever the column increase hits, we're so ready for it.

Kyla · 03/05/24

Bob Fraser

Oct 3, 2023

Hi folks,
I work on the Product team here at Smartsheet on this issue, and I'd like to give some feedback about our direction for new limits on sheets.
You may have seen on the Engage keynote that we're making scale a focus of our work right now and announced some major work in this area; we know that you're feeling pain around having to split your work up into multiple sheets when you'd much prefer to work in the same place on all your data. We hear you!
What we're aiming for as of now is the following sizes on a sheet:
5 million cells on a sheet (up from 500k)
Up to 1 million rows on a sheet (up from 20k)
Up to 1,000 columns on a sheet (up from 400)
So that could be expressed as up to 1 million rows with 5 columns, or up to 5,000 rows with 1,000 columns, or anything in between up to the 5m cell limit.
Additionally, we're aiming for no further surprises in terms of what you can put in those cells; you could have 5m cells links, or 5m formulas, with no further restrictions.
These numbers and goals aren't final, or binding - we may have to change some up or down slightly as we work through it, and I can't give you a hard timeline on this, as there's a lot of work we need to do behind the scenes to get there. However, I can tell you that this is something we're actively spending a lot of effort on right now.
What are all your thoughts?

Are there any new updates around timing and details for this enhancement? When I heard about this at ENGAGE I just about cried from happiness! This would be a huge help to my Smartsheet build. My team has metrics around Cash spend that need to be captured from current and prior years data, so there is no natural year-end archiving process that can happen to free up space. I considered at one point potentially utilizing sheet summary in the metrics sheet to store historical cash $values and re-writing formulas to pull from those cells in addition to pulling from the active data. Which would be a huge pain, potentially leading to errors, and doesn't allow for an easy way to dig into the specifics of the historical data. So this would be a total game changer!!

Pat Pontz · 03/12/24

Is there a specific implementation timeline for this increase in rows/cells? I would welcome this information as I have two projects impacted by the current limits. Many thanks!!

WyattMartinDale · 03/13/24

Hello all,

has anyone from Smartsheet provided an update on this ? I too heard about the increase limitations during ENGAGE and nearly cried from excitement. We have built a complex and very useful business tool through Smartsheet and are about to hit the limitations of the number of columns/cell/row combination. I will have to look for alternate solutions however if I had an idea of how far away these enhancements are that would definitely assist with building a solution timeline for my staff.

is someone from Smartsheet able to provide a date/month these enhancements would be available in 2024 ?

Nicole J · 03/26/24

Also sitting on the edge of my seat (and sanity) awaiting increased cells/rows/columns to sheets. Smartsheet, any updates to this timing?

hazkevi · 03/31/24

+1 here, I've been waterfalling data to "archive" sheets and crating tons of repetitive cross sheet references for dashboarding ability due to size limitations, but will soon reach the maximum character count for formulas. My Smartsheet account manager says this feature will be rolled out by "end of '24" which is not helpful at all. Currently we are exploring moving any another platform that can support our scale, sigh.

Adam Murphy · 04/18/24

The complete lack of response is very discouraging. I even had the Sales Rep reach out to me after my post in this thread to make sure I knew about release notes...which do not help at all in this case since NOTHING is being released, and would not respond further. Since the engage conference it's been nothing but crickets and only relatively meaningless enhancements being released. At this point even an acknowledgement that it is actually being worked on would be a vast improvement to the deafening silence here.

Smartsheet Product Feedback & Ideas

Smartsheet Product Feedback & Ideas

Sign in to submit new ideas and vote

Increase sheet row and column limits

Comments

FAQs and Guidelines for posting Product Feedback Ideas

Quick Links

Categories

Trending Ideas

PROPER Function

Auto hide the Workspace Shared to Panel. WHY ISN'T THIS FIXED YET?

IDEA: Populate Available Field Names After Typing Double Curly Brackets {{