I keep running into this limit:
Can this be increased? It's rather frustrating.
Sign in to see the current vote count, add your own vote, or leave a comment.
Where exactly are you pasting from? I agree that being able to paste more than 500 rows at a time would be helpful, but in the meantime we may be able to come up with a workaround for you depending on your exact needs.
Hi,
I hope you're well and safe!
Yes, I agree, but in the meanwhile, there are some workarounds.
Would any of those options work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅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!
Thank you for the suggestions. I'm working on a dashboard that is based on data from a large master sheet with over 2,000 rows. To make a pie chart based on this data, I need to make cell links from the master sheet to another sheet so that I can do data analysis there. I could do it directly in the master sheet, but that has many columns and I only need 1 column for the analysis. I can't make a cell link to an entire column, so I'm linking to the individual cells. Only, I can only make links to 500 rows at a time, so I have to repeat the linking process 5 or 6 times to cover all 2000-3000 rows.
So one limitation is that I can only link to 500 rows, the other that I can't link to a column.
I appreciate the workarounds, but I'm worried that my Smartsheet implementation and data analysis function is beginning to consist of a series of workarounds. I don't know if there is a way to avoid that. Maybe make the charting functions on dashboards more accepting of different data formats.
Thank you,
Marc
Happy to help!
What about using a cross-sheet formula instead?
✅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!
Depending on how exactly you need to run your calculations from that one column, you may be able to create a row report and use the grouping and summary features within the report to populate your chart.
Otherwise you should be able to use a formula with cross sheet references to run your calculations such as a SUMIFS or a COUNTIFS (or some of the other functions available.
What kind of calculations are you trying to run to generate the chart, and are you able to provide a screenshot (even with sample data) for context?
* I can't make a cell link to an entire column
=Index({Column reference},1)
then
=Index({Column Reference},1+count(Firstcell$1:Firstcell1)) and drag down.
I desperately need this option!!!!!!!! Pasting 35,000 rows from Google Sheets regularly.. smartsheet is linked to another external system so importing is not an option.
@Lisa B 2022 Do you have access to Data Shuttle?
Hello! It would be fantastic if you could either abolish or at least provide an option of getting rid of the 500-row restriction for copying and pasting!
I completely agree—lifting or providing an option to bypass the 500-row restriction for copying and pasting would be incredibly helpful, especially for managing larger datasets. Hopefully, Smartsheet considers this in a future update!
Is anyone able to paste near 1000 rows in Table view? I see it's marked as available now, but it will only let me paste 100-200 rows (20 columns)
Same here - super frustrating!
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
