External data written to a sheet, updated hourly, breaks my model when updated. Help?

M.OConnell

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?

M.OConnell

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!

M.OConnell

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!