Multi-Vendor Product Pricing Sheet

Hello!

I’m new to Airtable and have been struggling with how to build a pricing sheet that lists multiple vendors, products, pricing and quantities. We want the pricing sheet to be easily filtered and sorted by price, vendor, etc. And then we want to convert this sheet into a customer calculator to get pricing for products based on vendor, quantity, etc.

Any help would be MUCH appreciated!