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