How to export data to Excel without overwriting previously exported data.
Howdy! I have built a very robust sheet for collecting form submissions company-wide. We are currently maxing out our sheet cells every two months and I'm having to manually copy/paste the data to a running excel file that our Analytics team uses to connect with PowerBI.
Can I set up an excel sheet that just pulls 'new rows' from the smart sheet and does not delete rows I remove from the smart sheet? (I plan on deleting rows on a weekly basis in Smartsheet to avoid hitting our max cell count).
Every solution I've found overwrites all data within the Excel file so we can't have a running list of all submissions for our PowerBI dashboards.
Answers
-
Smartsheet won't do that natively. But you can use the Smartsheet data connector, and use Power Query to grab the data before you run your row deletion process, probably using Close and Load.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives