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.

Paul Newcome

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?