Pulling in data from external source
I work with large data sets on parts (60,000 SKUs) and I have a form and workflow for processing special pricing requests from our field. I'm curious if I can house the prices on an external excel file or sharepoint and pull in the pricing for an individual part. Since Smartsheet limits the row count to 5,000 I can't just have a master price list. What's my best possible route? I don't want to have 12 separate sheets because the price file updates weekly so I would have to update 12 sheets weekly vs. updating a single outside source.