Last updated

Limitations

While Smartsheet is improving capacity frequently, there are some hard limits that might be helpful to know:

  • When adding or updating rows, limit your request to 500 rows at a time.
  • A sheet cannot exceed a total of 500,000 cells. To determine how close you are to the 500,000 cell limit, multiply the number of columns in your sheet by the number of rows. For example, a sheet with 20,000 rows can only have 25 or fewer columns, and a sheet with 400 columns can only have 1,250 or fewer rows.
  • Any one sheet can have up to 500,000 inbound cell links. (Smartsheet Gov has an inbound cell link limit of 100,000.)
  • No cell can contain more than 4,000 characters.
  • When using a GET /reports/{reportId} call with paging, the default is 100 rows. If you need larger sets of data from your report, this operation can return a maximum of 10,000 rows per request.
  • Reports are limited to 50,000 rows.
  • When sharing emails, you can send 1000 per API call.

The following features aren't yet supported for sheets with more than 5000 rows, or more than 200 columns:

  • Bridge by Smartsheet
  • Quip connector
  • Tableau connector
  • PowerBI connector
  • Zapier connector
  • Google Docs Merge connector
  • Google Forms sync connector
  • LiveData connector
  • Calendar App