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

  • M.OConnell
    M.OConnell ✭✭
    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

  • M.OConnell
    M.OConnell ✭✭
    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!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!