Help

Creating a Conditional Rollup Base

Topic Labels: Formulas
1006 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Troy_Christy
4 - Data Explorer
4 - Data Explorer

I have two tables, and I want one to display a sum of a column if it meets

Table 1
House # | Free Nights Total | Total Nights Used|
House 1 | 5 | 4 |
House 2 | 3 | 2 |
House 3 | 9 |

Table Two
Guest Name | House # Used | Free Nights Used
Guest 1 | House 1 | 2
Guest 2 | House 3 | 5
Guest 3 | House 1 | 4

What Im looking for is the “Total Nights Used” column in table 1 to total up each Houses used Free Nights

Hopefully that makes sense??? And apologies if this question has already been answered!

1 Reply 1
Btbml
7 - App Architect
7 - App Architect

I’m not sure if I completely understand your application but I’ve mocked up a quick base. The solution I used was to use a 3rd table, then use rollups to total data.

0d41b7239ab01c5f5e8f76a7f7d714f76ba86a36.png

House/Guest - Airtable

Explore the "House/Guest" base on Airtable.