Is there a solution or workaround for importing excel sheets every time content changes?
Currently our client submits an excel sheet with every project/request and we then create our own shared excel sheet by copying all the same content from the clients excel sheet and pasting it on to our own internal one. We add in a couple new/different columns and change the order around very slightly but all the information is basically the same for the most part.
The issue is that very often, the client will sometimes cancel some of the deliverables that were originally listed on the excel sheet submission or they will often add in additional deliverables but often they never let us know of these changes.
Having to constantly and manually update our internal excel sheets is very time consuming and also sometimes leaves room for error when copying and pasting. I am wondering if there is a solution within Smartsheet.
Any help or guidance is appreciated. Thanks!