Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Summarize forecasted quantity per product

Topic Labels: Formulas
219 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