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! 🙏
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…
I noticed this the other day and tested Ctrl + M – it does not work. I submit ticket to Smartsheet support – they told me that’s expected behavior because it’s not currently available even though it still shows as keyboard shortcut in the menu🙄 and told me to submit new product idea. Please add this keyboard shortcut to…
Summary of Issue All team members work a standard 7.5‑hour day, but only a portion of that day is allocated for project work (e.g., 25%, 50%, etc.). In Resource Management, however, the system currently interprets allocations as a percentage of the full 7.5 hours, instead of the project‑eligible portion of a person’s day.…
