Hey y’all. I’m creating a system to track stats for esports competitions. I want to be able to create a new table to represent the game, choose which team is playing, and then it will fill in the players. For the most part, I have that worked out. The problem is, I want to fill in how many assists a player gets in a game on that table, then automatically add that to the player’s total assist number in a different table. Any suggestions on how to do this?
Hi @Coby_Bartolucci Welcome to the community 
Could you add a sample doc here so we know how you have designed it so far and what you want to do. Much easier to work together in a doc.
Thanks for sharing @Coby_Bartolucci! It sounds like you’ll want to use a filter to find the player’s matching kills and sum them. For example, if the Kills column in Quarter Finals > Table 2 is where you want to pull from, you could configure a formula in Column 4 in your Players table like this:
[Table 2].Filter([Player Name]=thisRow).Kills.Sum()
Generally speaking when you want to run a column formula over a subset of data in another table, you’ll want to filter the data first and then perform the operation. Here’s a copy of your doc where I’ve set that formula up in the Players table:
The formulas course might also be helpful if you haven’t taken a look yet: https://coda.io/learn/formulas/welcome
Let me know if that works for you!
2 Likes
Wow, this is SUPER helpful!!! Thank you so much!
One more thing though. If I wanted to make another game in a different table on the “Quarter Finals” page, I’d have to manually add that table to the sum formula, right?
You wrote:
[Table 2].Filter([Player Name]=thisRow).Kills.Sum()
But if I wanted to include all tables on the “Quarter Finals” page, could I do that instead of just including [Table 2]?
1 Like
Ah good question!
Depending on the tables you’re intending to add to that section, I think instead of creating several different tables, you might want to create a single master table that contains all your data, then create multiple views of that table. That way, you can sum the values from a single table and not need to constantly update your formulas if you add more views.
Here’s a quick video on views! If you can talk a little bit about the additional tables you’re thinking of I’ll be happy to walk through how you might set up views to handle that.
Otherwise, you’ll need to create something of a nested sum formula that sums the dataset pulled from each table. Something like this:
Sum([Table 2].Filter([Player Name]=thisRow).Kills.Sum(),[Table 3].Filter([Player Name]=thisRow).Kills.Sum())
That should work for multiple tables (just comma separate your filtered sums), but means you’ll need to manually adjust your formula for each table you add.
I hope that helps!
3 Likes