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! 🙏
I have a workflow with nearly 40 automations, half of which are email-based requests for updates with various sets of triggers. While I know the automations work, due to months of testing, when our system went live to the institution, I became very worried that the automations wouldn't run and I'd have no idea whether or…
Our consistent experience is that Smartsheet objects can take anywhere from 5-20 seconds to load. This feels extremely slow when you're actively facilitating a call and working between sheets, waiting for it to load. Other solutions in the industry have extremely fast, sub-5-second load times. I would request the product…
Description: When users upload multiple photos in one action via the Smartsheet iOS mobile app, all files are assigned the same generic name and timestamp. This makes it difficult to identify individual photos and creates confusion in workflows that rely on accurate, unique file naming. Why This Matters: Industry Standard:…