Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 10, 2018 08:21 PM
I have a column in the first table with dollar amounts like this:
etc
I would like the second table (in the same view) to total these amounts. How would I go about doing that? Thanks
Jan 13, 2019 10:29 AM
did you ever figure out how to do that?
Jan 13, 2019 12:18 PM
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.)
X
’ in the upper right corner of the window.Now here’s where those clicks and keystrokes come in:
Ctrl-C
to copy.the value.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.
Jan 13, 2019 02:48 PM
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
Jan 14, 2019 12:08 AM
Awesome, thank you Jeremy_Oglesby !!!
May 23, 2019 09:34 AM
wait, so you said that airtable is better than spreadsheet, but this very basic function, airtable can’t do. Very frustrating.
May 30, 2019 01:48 PM
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.
Apr 09, 2020 10:44 AM
genius works like a charm!
Aug 17, 2021 06:31 AM
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.
Feb 02, 2024 07:47 AM
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.)