Sign in to join the conversation:
Has anyone received this error message before? What are the options for large data?
Error
Hi David,
How many rows/columns do you have in the sheet? Do you have large attachments?
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant @ Get Done
I received this before when collecting data. Once my sheet reached I think it was 5000 entries (no attachments 22 columns) it automatically closed my form. I didn't realize until someone notified me that the form link was broken.
I save multiple data files to a smartsheet workspace then run the report using the entire workspace as the source (see "Where?" in report builder).
Limits:
5000 rows
200 columns
200,000 cells (not 5000x200)
Craig
Is there a file size limit as well? I am receiving that error on a sheet with only 3000 rows and about 30 columns.
I'm facing the same problem with 3333 rows...
@Mariam_Lolua Can you provide more details as to the setup and desired function of your sheet(s)? Unfortunately there is no way to increase the limits per sheet, but there could be a solution using multiple sheets in conjunction with various other features that could help your sheet continue to work without exceeding said limits.
The SSFeatures browser extension can help here.
It lets you see how close you are to all of the limits (rows, columns, cells, cross-sheet references, etc), and it alerts you when one of your sheets is close to a limit.
This way you have time to restructure the sheet before it breaks.
You can read more about this feature, and watch a demo video here:
Hope this helps!
Disclosure: I'm the creator of SSFeatures.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…