My workflow requires me to update a big chunk of data every week. It's about 7500 lines so I cannot copy-paste it, I can only import it from excel. Once the data is in smartsheet, I use vlookup to reference the values of specific columns in another sheet.
The issue is that each import creates a new file so my vlookup reference needs to be updated every time which is manual, time-consuming and cumbersome.
Is there an easier option other than the premium data shuttle that our company doesn't pay for?
Thank you.
