Help

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

Sum up the fields of a colomn from a different table

Topic Labels: Formulas
398 4
cancel
Showing results for 
Search instead for 
Did you mean: 
MarineSorato
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello community,

I'd like to use a field from a different table in a formula.

How can I do this ?

--

I have a table with a list of attending people to a specific event and how much they paid.
I have a table with a list of the different events and I want to display the total payments received. 

Marine

4 Replies 4

Does this look right?

Screenshot 2024-08-21 at 6.00.36 PM.png

Screenshot 2024-08-21 at 6.00.45 PM.png
If so, it's a Rollup field with the formula `SUM(values)`

Link to base

Hello Marine,

You can do that by adding a rollup field in your Events table.

First step, if not done yet, is to link "Attendees" table to Events Table:

Pascal_Gallais_0-1724234335965.png

Field "Events" is a linked field to table Events:

Pascal_Gallais_1-1724234415521.png

You then add a rollup field in table Events:

Pascal_Gallais_2-1724234485681.png

To get the following result:

Pascal_Gallais_3-1724234522962.png

Regards,

Pascal

 

Sorry,

I started writting my answer before Adam posted his answer.

Do not consider my answer.

Regards,

Pascal

@MarineSoratoAh, please consider Pascal's answer; his is clearer than mine and includes a step by step process of how to create the rollup field

@Pascal_Gallais-Hahaha I've done this a couple of times too, sorry about that!