Can I reference rows of data in a separate table to perform an average in the table I am working on?
Additionally, can you indicate how many rows of data should be calculated in that average? For instance 1 record I might want to reference 4 columns ...
is there a way to create a table with a list of products from another table that have the same vendor, in other words have a self updating table with only Coca Cola products without having to copy all the info from the main table its pulling from?
Hello All,
I am looking for a formula that will calculate historical orders placed with the option to query 14, 30, 60, 90 and all time order history. Is there a way to do this? I am very new, go easy on me :slightly_smiling_face:
This is a screen shot from the spreadsheet I am using currently to perform this operation. Hopefully this helps illustrate what I am trying to do. What I need is more flexibility when calculating historical averages depending on the type of product ...
and I’ve stumbled onto filters which might work for filtering by vendor. now I just need to figure out how to perform the calculation as to how much order history to reference for each product, also if I keep creating a new column for every order it ...
I’d like a “master product list” table that holds the item name, vendor name and previous order dates. then id like to populate additional sheets based on vendor that will allow me to look at one specific vendor when placing an order.
in other words ...
I don’t have the pro plan (yet) I’m trying to teach myself (with your help) Airtable before deciding to invest. Ideally id have a list of products and then a field that allows me to choose how that specific products purchase history is referenced.
fo...
