Want ability to import to an existing sheet - option to import should allow ability to append or overwrite
Sign in to see the current vote count, add your own vote, or leave a comment.
Currently, if you are in a Grid Sheet, and use the File path to "Import" via Microsoft Excel, the import creates a new sheet, names is the name of the document you are importing and locates in your personal Sheets workspace. There have been many times I have started a sheet, decided to import Excel data, and then lose the sheet because it did not retain the name I gave it or the location I started in. This is very confusing, and does not match the process of importing into the workspace outside of a sheet.
Create a feature where we can load to existing Smartsheets by adding rows to the end. Loading only to a new Smartsheet isn't helpful and creates additional work when we have to merge data
Load what and how exactly? Data Shuttle, the API, the premium add-on Bridge, and various other third part apps have the ability to add rows tot he bottom of a sheet, so knowing exactly what process you are referring to would be helpful.
Hi, I hope you're well and safe! Here's a possible workaround.
The fantastic add-on, which makes this possible (+ many other features).
SSFeatures from the brilliant Nathan. @SSFeatures
Would that work/help?
I hope that helps! Be safe, and have a fantastic day! Best,Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD ✅ Did I help answer your question/solve the problem? Please support with 💡 ⬆️ ❤️ and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏
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…
As one of the system admins, it is absurd to me that I cannot view or have access to all of the items created in my organization. We have over 11,000 reports, sheets, and dashboards and I can't see them. I have no visibility to if people are using our plan for their own personal use, or what kind of work is going on unless…
Today you can create a form and add logic. If that logic requires that requests need to be made for X days in the future you can add logic to help. For instance is the date requirement is not met you can hide fields so that information cannot be submitted completely. You can display a banner if date requirements are not…
