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!
Most customer's metadata houses their profile data, some from intake sheet and some either cell linked in or brought into metadata using formulas. Needs change after design and often the new data point needed comes from non-metadata templates, which can cause a blocker if methods used are those above. If it were possible…
Having the ability to auto-resize the Calendar App view based on the widget size is needed. We have a "Due in 7 Days' calendar for our dashboards and would like it to be anchored at the top right. Unfortunately, as currently designed, the calendar takes up a significant amount of space and must be moved to the bottom.
Our sheets & workspaces require many people to have Admin level capabilities, which means that when someone requests access to a sheet or workspace, that email is sent to every Admin. This causes confusion and higher risk of no access granted (because people have learned to ignore the emails) or the wrong level of access…
