Importing Excel Spreadsheets into Smartsheet

I am trying to automate a function that we desperately need. We have a spreadsheet that is generated every morning and every night. I want to import it into a Smartsheet that I will use for a Dashboard. My problem is that every time I import the spreadsheet it creates a new Smartsheet and I lose my Summary fields. I need it to dynamically update my Dashboard.

Is it possible to import the data into the same Smartsheet every time so I don't lose my Summary fields?

Best Answer