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.
  • You cannot create or update filters using the API; however, you can query which rows have been filtered out and you can get filter definitions. For details, see Filters object.

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