Smartsheet performance with large amounts of data

Cherie Dooley

We are looking at using Smartsheet to replace some massive excel files. The files can have 10,000+ rows of data. There would need to be vlookups across multiple sheets. Has anyone used SS with this amount of data? Are there any issues with performance or hitting limits?

Jeffrey Anderson

@Cherie Dooley

Current row limitation is 20k rows.

Couple of options you can use:

1) Data mesh (premium app). This can do the heavy lifting and can be bi-directional or 2) use the Index(Match) combination formula instead of VLOOKUP. VLOOKUP source sheet needs to be alphabetized in order to function correctly. Index/Match is based on a coordinate in the source sheet and is much more efficient. For more on this functionality please see URL below:

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

Additional information on Data Mesh:

https://help.smartsheet.com/articles/2476796-get-started-smartsheet-data-mesh

If you have any questions, please let me know.

Respectfully,

Jeff