Pulling in data from external source

Nolan Schmidt
✭✭✭
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.
Answers
-
How many columns would your price table take up? Could you replicate the table across multiple columns within the same sheet so that you don't exceed the 5,000 row maximum?