I know you can create a sheet by importing a document into SmartSheet and having it auto-create around the information; however, how do you continue this? IE You take a sheet from Excel, that will continue to be used, and import it into SmartSheet, then you want to update the information in the SS later by just Uploading\Importing the updated document. How is this achieved/is it even achievable at the present state? I am trying to get away from having to input several packets of information into various databases. If I built a dashboard based on a sheet in SS I don't want to have to create a brand new sheet importing every time and then have to go back and edit all of my formulas.
There ought to be an easy way to update sheet information with some form of upload capability versus re-entering all data that has been input by the production crew in excel already.
Open to other suggestions as well that meet the same goal.
TLDR;: Production inputting information into a program that is output as .csv and then uploading into an existing sheet. Presently no way to add info into same sheet, (That I see), importing creates new sheet. How does one go about updating an existing sheet with an outside file, IE .csv or .xlsx.
Help Article Resources
Check out the Formula Handbook template!