External data written to a sheet, updated hourly, breaks my model when updated. Help?
I have 8 or so files that are updated hourly from our ERP that live in a folder within a workspace. Things like inventory, PO, and other data, that I am then referencing thru lookups or sumif's from other pages to manage an aspect of our business. Everything works fine, until the files are overwritten as part of the hourly update, completely breaking the data model.
Is there a way to have a dynamic relationship with external data that I can reference consistently, regardless of how many times it gets refreshed?
Best Answer
-
Looks like we fixed it ourselves. We were able to change the way data was being written into SmartSheets... instead of deleting and replacing the file (which broke any existing connections) we were able to delete all lines within the sheet, and re-write them. This kept the structure intact, meaning formulas and lookups continue to work after the data is wiped and rewritten.
Hope this helps someone!
Answers
-
Looks like we fixed it ourselves. We were able to change the way data was being written into SmartSheets... instead of deleting and replacing the file (which broke any existing connections) we were able to delete all lines within the sheet, and re-write them. This kept the structure intact, meaning formulas and lookups continue to work after the data is wiped and rewritten.
Hope this helps someone!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!