Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Multiple values in one field Sum up in another cell

442 1
cancel
Showing results for 
Search instead for 
Did you mean: 

image

if i place a order for example 500 and then it is part shipped in 5 deliveries resulting in 5 invoices . can i have all involves values in one cell ( 100+100+100+100 ) this is then sum into new cell giving me a value of 400. i dont want to be creating new columns for every part invoice . as some order may come in anything up to 10 part shipments

1 Reply 1

Hi @Site_Team,

I think you are modeling your data wrong. You can do something like this:

  1. Create two tables – Orders and Invoices.
    image
    image
  2. The Orders table links to the Invoices table
    image
  3. Add a roll up field in the Orders table.
    image