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
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives