Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Sum of all amounts in one column presented in another table

8528 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Henry_Dalziel
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a column in the first table with dollar amounts like this:

  1. $20
  2. $20
  3. $20

etc

I would like the second table (in the same view) to total these amounts. How would I go about doing that? Thanks

18 Replies 18

did you ever figure out how to do that?

To link 300 (or 3000, or 30,000) records in one table to a single record in another table takes 2 mouse clicks and 2 keystrokes… (Well, after you link the first record, that is.)

  1. Create a view filtered to show just those records you wish to link. (Obviously, if you want to link all records in the current table, you simply use an unfiltered view.)
  2. Manually link the first record in the table to the target record. If the target record doesn’t exist, select ‘Create a new record.’ Note: While Airtable will let you link to unnamed records, in this case you should give the record a name — that is, make sure the primary field of the first record contains a value.
  3. Close the expanded target record by he ‘X’ in the upper right corner of the window.

Now here’s where those clicks and keystrokes come in:

  1. Mouseclick 1: Select the linked record field for the first record in your large table.
  2. Keystroke 1. Press Ctrl-C to copy.the value.
  3. Mouseclick 2. Select the column header — that is, the field name — for the linked-record field. A message will appear in the lower left corner of the screen reading ‘300 [or 3,000, or 30,000] cells selected.’
  4. Keystroke 2. Press Ctrl-V to paste the value. Depending on how many cells were selected, you may be prompted to confirm this is something you really want to do. Answer ‘Yes’. A message will briefly appear, again in the lower left, saying ‘Pasting…’. Once the value has been pasted into all selected cells, the message changes to ‘Pasting complete’, with an option to undo.

Since you pasted the same record name into the linked-record field of every record in that view, you’ve now linked each of those records to the single target record with that name. You are now free to follow @Jeremy_Oglesby’s advice, above.

There are other tricks and shortcuts possible in support of this all-to-one linking, as documented here.

Hi @W_Vann_Hall

This is so neat.

I will be referring back to the above instructions.

I do enjoy learning new things and this is one of them.

Thank you,
Mary

Peter_Vellenzer
5 - Automation Enthusiast
5 - Automation Enthusiast

Awesome, thank you Jeremy_Oglesby !!!

Lam_Thai
4 - Data Explorer
4 - Data Explorer

wait, so you said that airtable is better than spreadsheet, but this very basic function, airtable can’t do. Very frustrating.

Armando_Gomez
4 - Data Explorer
4 - Data Explorer

Hey guys, for this purpose use ROLLUP feature selecting the table, the column and including the formula in this case use sum(values). Great tool, I will love to be a reseller or partner.

genius works like a charm!

Thanks for providing a response here. Is it possible to do this if your columns are grouped? I want to add the sums of each column for each group to another table in the same view.

feliciachavez
4 - Data Explorer
4 - Data Explorer

I'm having a similar issue.

I can do the rollups on another table, but I can't figure out how to sum across years (as records) down a *single* vertical column (field). Instead, I still end up with 2023 rolled up in one column/field, 2022 rolled up in the next, etc., which is essentially what I started with in the first place. (See attached image.)

I'm trying to arrive at a neat, tidy little summary table; example of a manually entered version attached. (And yes, I've spent hours and hours on this as well, from various websites, YouTube videos, Airtable help, etc.)