
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 10, 2018 08:21 PM
I have a column in the first table with dollar amounts like this:
- $20
- $20
- $20
etc
I would like the second table (in the same view) to total these amounts. How would I go about doing that? Thanks
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 13, 2019 10:29 AM
did you ever figure out how to do that?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.)
- 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.)
- 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.
- 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:
- Mouseclick 1: Select the linked record field for the first record in your large table.
-
Keystroke 1. Press
Ctrl-C
to copy.the value. - 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.’
-
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 14, 2019 12:08 AM
Awesome, thank you Jeremy_Oglesby !!!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 09, 2020 10:44 AM
genius works like a charm!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.)

- « Previous
-
- 1
- 2
- Next »