Max File Limit and Export data/files

dfortuna

Good Afternoon...

Is there a maximum limit on the number of files that can be attached to a sheet and is there a maximum number of rows in a sheet?

Also, if we max out on the number of files/rows in a sheet, is there a way to offboard/download the files, attachments, discussions from Smartsheet into another program?

Thank you,

Debbie

Colleen Patterson

Smartsheet Standard Sheet maximums:

• Rows: 20,000
• Columns: 400
• Cells: 500,000
• Characters in a cell: 4,000

There are export functions that are available within the sheets for free are export to: excel, pdf, etc.

If you are wanting to export into something greater (ERP, CRM, etc) you may want to explore Data Shuttle: https://www.smartsheet.com/marketplace/premium-apps/data-shuttle

As far as attachments go, those are dependant on file storage capacity within smartsheet, you would want to explore Data Table, which allows up to millions of rows of data, which can by sync'd into sheets.

https://www.smartsheet.com/marketplace/premium-apps/datatable

Andrée Starå

Hi @dfortuna

I hope you're well and safe!

To add to Colleen's excellent advice/answer.

File storage capacity limits

• Business: 1 TB
• Enterprise: Unlimited

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!

dfortuna

Thank you for the information. If we were to use the backup feature and include the attachments, is there a way to offboard into another program? I tried to export a sheet with attachments in an Excel and PDF format but it did not export any of the attachments.

Andrée Starå

@dfortuna

Happy to help!

Yes, there are multiple ways. What do you want to do with them?

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!

dfortuna

If we move away from tracking the information in a Smartsheet, we want the ability to move all the info, attachments, comments, etc. to another file format. There will be a number of attachments for each line and the concern is maxing out the allowable Smartsheet space. Thank you!

dfortuna

Just to clarify, a file size maximum is 250 MB, but a Smartsheet sheet can hold 1TB of info? We have run into issues with maxing out attachment capacity.

Andrée Starå

@dfortuna

If you have Enterprise, it's unlimited.

Does that solve it?

dfortuna

No, we do not have Enterprise.

Andrée Starå

@dfortuna

Ok.

The tricky part when you backup/export is that there's now a simple way to know which rows the attachments we're tied to, but other than that, you should be good.

Would that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!