Inventory Sheet, moving data to/from Excel and SmartSheet
While I have a lot of experience with Excel, I am new to Smartsheet. I've been given a project and I'm having difficulty finding a way to perform what I need in Smartsheet, and am looking for advice/help.
Effectively, I have a master inventory list that is kept in Smartsheet of equipment we are configuring and will then deploy to a government site. When we deploy, the equipment will go all over their institution, so I will have multiple engineers at multiple locations simultaneously. To make things just a little more difficult, the site is hardened, so we cannot use any wireless signals nor have access to the internet when out in the field. So my plan for the inventory file, is to export it from Smartsheet into Excel, and have each engineer, take a copy with them on their government approved laptops. They will then install the hardware (or take a new inventory in case things have moved since we were last at a particular site), and update their copy of the file (which is all done by scanning barcodes). When they return back to us at the end of the day, I want them to upload their Excel file back into Smartsheet, and have the system add their updates into the master file. But from what I've been reading so far, it doesn't look like Smartsheet supports uploading an Excel file into an existing Smartsheet sheet; it will only create a new file. Being that the file is quite large, copying and pasting isn't really a reasonable option.
If there are any other importing/linking options that anyone can recommend, I would love to hear them. I'm not afraid to code/ODBC/API/etc. link if necessary.
Thank you for your time and effort!