Help

Rollup filtered by record

1281 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Thomas_Grist
6 - Interface Innovator
6 - Interface Innovator

Hi there,

Is it possible to do a rollup field where you only add the values based on a certain criteria?

Please see the graphic below which I think illustrates what I’m trying to achieve vs. what I’m currently getting with a SUM(values) rollup field.

Group3.png

I think I have to try and write a conditional rollup. I tried this: IF({Player} = {Player}, SUM(values), 0) but with no luck (probably obviously). In plain English the formula I am trying to write is - if the player is David, show David’s career points total.

Any help would be greatly appreciated.
Thomas.

4 Replies 4
Thomas_Grist
6 - Interface Innovator
6 - Interface Innovator

Please ignore this.

It works with the simple SUM(values) rollup - I just hadn’t linked the records correctly.

Heh… I was working on a solution for you and figured you just did not have your links done correctly.

Here’s the example base I made for reference, but I’m glad you figured it out:

0d41b7239ab01c5f5e8f76a7f7d714f76ba86a36.png

Sports - Airtable

Explore the "Sports" base on Airtable.

Thomas_Grist
6 - Interface Innovator
6 - Interface Innovator

Cheers Jeremy - yeah you nailed it. Me not so much. Thanks for your help.

How do I link to another record with just text? It’s coming from an app.