I got the error below on our first attempt to import an excel file, so we made some edits and shortened it to 1,100 rows and gave it a new name. However, we still receive this error attempting the import. What gives?
Hi @Tina Rustvold
Do you have other tabs in that excel file? If so, try making the first tab its own file, then import this instead. Although the import will only grab data from the first tab, sometimes the other tabs can cause the upload to fail if they exceed limits.
Let me know if that helped!
Thanks Genevieve--that was what stumped me, it did not.
It was almost as if Smartsheet wasn't reading the changes. I even designated the 1100 rows as a print area, thinking SS was still reading anything ghosted in the previous cells. So weird...ended up coping the the rows to an entirely new file and that did the trick. Glad to know I was on the right track, but also thought it was good for the SS gurus to know about. :)
Yes, it's good to know that you came across this error with only 1100 rows! Thank you for posting your question and your resolution.
Can you help me please?, I need to import a lot of date from excel and from different files, and my data is so big in all the cases because I need to analyse historical information so in my case I cannot cut any info.
How can I do this in Smartsheet?
If your file is too big to import into Smartsheet, you'll need to break it out into different documents and import it as multiple, separate sheets.
Here are some help articles that have more information:
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
I'm working on a compensation request form that follows these steps: An HR Business Partner completes the Compensation Request Smartsheet Form that then triggers an alert to our Compensation Manager. Our Compensation Manager will insert the requested information. The HR Business Partner will be alerted when the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.