Allow pasting of more than 500 rows

mdemul

I keep running into this limit:

Can this be increased? It's rather frustrating.

Paul Newcome

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.

Andrée Starå

Allow pasting of more than 500 rows

mdemul

Aug 17, 2023

I keep running into this limit:

https://us.v-cdn.net/6031209/uploads/X22DVCGMCQH5/image.png

Can this be increased? It's rather frustrating.

---

View Post

Hi,

I hope you're well and safe!

Yes, I agree, but in the meanwhile, there are some workarounds.

• Import an Excel sheet, and then move the rows
• Premium app, Data Shuttle.
• + more

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!

mdemul

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

Andrée Starå

mdemul

Aug 18, 2023

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!

Paul Newcome

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?

L_123

* 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.

Lisa B 2022

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.

Paul Newcome

@Lisa B 2022 Do you have access to Data Shuttle?

kohei_DAI_29

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!

ChristianFinke

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!