7

Dear Smartsheet:

I am a bit confused by the 25,000 cell reference limit.  In my specific case I am simply trying to VLOOKUP from a table where I have 700 rows and 17 columns.  That equals 11,900 cells which is less than 25,000 cells. 

So, why am I getting this error?  It creates an incredible amount of frustration and dissatisfaction with your product. 

Please help.

Francisco

 

Functionality
Industry
Department

Comments

I ran into the VLOOKUP cell limit pretty quick in my usage. I started using INDEX/MATCH instead and haven't had any problems yet. Maybe it will work for you as well. The benefit is that you only reference the columns you are searching, rather than an entire grid. More info here:

https://help.smartsheet.com/function/index

Hi Francisco,

What's the error message you're getting?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Same here. I have 511 rows/ 35 columns - that is NOT 25000. Super frustrating.

Are you selecting the entire columns or just those x amount of rows in each column?

We hit this ridiculous limit.  We have a large organization and this limit blew up our whole project that has been working superbly.  Not sure where we go from here.  I do not believe we have a good way to fix unless Smartsheet raises the limit to at least 100,000.

 

I have a summary tabulation sheet for each of our users (over 300) that uses cross references to a few master sheets that are growing in row count daily.  I need to keep a years worth of data before I can archive.  Now my summary sheets aren't calculating because I have hit the limit half way through the fiscal year.  Might be time to migrate away from Smartsheet, too many limitations with row cell counts and cross references, etc...