Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Summarize forecasted quantity per product

Topic Labels: Formulas
288 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Okay, so I’m new to AirTable, trying to move away from Excel sheets :slightly_smiling_face:

I’m creating a forecasting tool for my sales department. For each project we forecast the number of products that we will sell.

For my purchasing department, I’m creating another tool that will use the summarized number of forecasted products in calculations.

So for example
Project 1:
Product 1 - 30 pcs.
Product 2 - 10 pcs.

Project 2
Product 1 - 5 pcs.
Product 2 - 10 pcs.

I need the sum of Product 1 (35 pcs) and Product 2 (20 pcs) available for further use in another table.

How can I do this?

image
These qty I would like to summarize in the Product table.

image

1 Reply 1

Please have a look at Airtable’s Rollup formula, which does what you want to achieve (using Sum() as the aggregation formula): https://support.airtable.com/hc/en-us/articles/360042807233-Rollup-field-overview