# Addition of two Relations (match simple)
**URL:** https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052
**Category:** Ask for Help
**Created:** [July 24, 2020, 2:51pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052 "2020-07-24T14:51:38Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@noneight](https://community.glideapps.com/u/noneight)
#### Post date: [July 24, 2020, 2:51pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/1 "2020-07-24T14:51:38Z")
Hello Guyz 😀,
Do you know if there is anyway to additionate two relation like :
In order to have something like :
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 24, 2020, 2:53pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/2 "2020-07-24T14:53:34Z")
How are you structuring the destination sheet where you match the relation?
---
### Author:  [@noneight](https://community.glideapps.com/u/noneight)
#### Post date: [July 24, 2020, 2:56pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/3 "2020-07-24T14:56:37Z")
Hey ThinhDinh 🙂,
Here your answer :
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 24, 2020, 3:00pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/4 "2020-07-24T15:00:53Z")
I would imagine to have something like you want you must structure it like “Marble color - Race posiiton 1 - Race position 2” and match the marble color together.
---
### Author:  [@noneight](https://community.glideapps.com/u/noneight)
#### Post date: [July 24, 2020, 3:13pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/5 "2020-07-24T15:13:47Z")
In a Rule Tab? or Leaderboard Tab?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 24, 2020, 3:18pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/6 "2020-07-24T15:18:21Z")
Match the marble color in Leaderboard sheet to the marble color in the the sheet where you store the race results (do you structure it like Marble color, Race number, Race position?). Set it to match multiple.
In the sheet where you store the race results, relate the race position to the Rule sheet and use a lookup to get the points back.
Then in the Leaderboard sheet, make a rollup of the original relation in the 1st step, get the sum of the points you just get via the lookup.
Does it make sense?
---
### Author:  [@noneight](https://community.glideapps.com/u/noneight)
#### Post date: [July 24, 2020, 3:25pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/7 "2020-07-24T15:25:46Z")
I don’t get it.
**Leaderboard** tab is where i store all data. Room / marble colors choosen per room etc…
**Rule** tab, is where i store result (i shoul hve called it “result” 🤣 )
Each result race will be a new column. (example : Race 3)
With that cofiguration do you have an idea 😬
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 24, 2020, 3:28pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/8 "2020-07-24T15:28:15Z")
Can you match a marble color to an array column (the races)? I guess not?
---
### Author:  [@noneight](https://community.glideapps.com/u/noneight)
#### Post date: [July 24, 2020, 3:35pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/9 "2020-07-24T15:35:28Z")
> [@ThinhDinh](#):
>
> array
It is what i did no 🤔
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 24, 2020, 3:37pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/10 "2020-07-24T15:37:25Z")
You match it to only one column, what I mentioned was an array column.
---
### Author:  [@noneight](https://community.glideapps.com/u/noneight)
#### Post date: [July 24, 2020, 3:40pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/11 "2020-07-24T15:40:14Z")
It works !!! thanks a lot ThinhDinh, again 🎆
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 24, 2020, 3:41pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/12 "2020-07-24T15:41:00Z")
Oh I learned something new as well, I have not tried this lol.
---
### Author:  [@noneight](https://community.glideapps.com/u/noneight)
#### Post date: [July 24, 2020, 4:09pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/13 "2020-07-24T16:09:02Z")
Okay so i am close to my goal.
Now i have thoses data in my **leaderboard tab** , and i would like to have the same one in my **user pofil tab**
I tried with a simple look up from my **user pofil tab** , but i can’t, it would be too easyer…
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 24, 2020, 4:11pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/14 "2020-07-24T16:11:58Z")
Why can’t you make a relation for that? In the Leaderboard tab you have the email of the user as well right?
---
### Author:  [@noneight](https://community.glideapps.com/u/noneight)
#### Post date: [July 24, 2020, 4:14pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/15 "2020-07-24T16:14:29Z")
I think i did. No ? 🤨
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 24, 2020, 4:20pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/16 "2020-07-24T16:20:19Z")
What are you trying to bring back from the leaderboards tab? Isn’t it the score total column?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 24, 2020, 4:20pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/17 "2020-07-24T16:20:49Z")
If you’re setting the match to a multiple, would the total points be calculated by a sum rollup on that leaderboard relation?
---
### Author:  [@noneight](https://community.glideapps.com/u/noneight)
#### Post date: [July 24, 2020, 4:24pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/18 "2020-07-24T16:24:04Z")
I am sorry, no.
I am want to bring back the **All Position** column from the **leaderboard** to the **user profil**
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 24, 2020, 4:27pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/19 "2020-07-24T16:27:08Z")
So you have the emails in multiple rows and now you want to bring back all positions related to that email in those rows? I’m not sure if that is even possible.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 24, 2020, 4:28pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/20 "2020-07-24T16:28:31Z")
If you have a relation - lookup bringing back all choices of marble color associated to an email in a column in your user profiles, can you make a relation to match that lookup with the array column in the Rules sheet?
[Next page](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052.md?page=2)