Novicesportsperformer
New Member
- Joined
- Nov 21, 2016
- Messages
- 37
Hi All,
Wondering if you could help me with this as I am struggling
I am trying to create a dashboard on my athletes
So far i have headers of my variables and the player names down the column. Above the table is week i want to look at specifically, there for i need a formula that link specifically to the cell (N1)
This has worked for me before with formulas such as =IF(O6>0,SUMIFS(TBLLoadDB[GPS Total Distance],TBLLoadDB[Player],$N6,TBLLoadDB[Week Number],$N$1),"")
However, I am copying from another table called 'TBLACTeam' - specifically a percentage.
I am trying to get a formula that will give me a specific value from TBLACTeam, for a specific week and for a specific player onto a separate worksheet
I have had no success with: =IF(O3>0,SUM(TBLACTeam[A:C TD],TBLACTeam[Player],$N3,TBLACTeam[Week number],$N$1))
Can anyone help me out?
Really appreciate this as this would massively my Sport Science Manager out.
Thank you
Lewis
Wondering if you could help me with this as I am struggling
I am trying to create a dashboard on my athletes
So far i have headers of my variables and the player names down the column. Above the table is week i want to look at specifically, there for i need a formula that link specifically to the cell (N1)
This has worked for me before with formulas such as =IF(O6>0,SUMIFS(TBLLoadDB[GPS Total Distance],TBLLoadDB[Player],$N6,TBLLoadDB[Week Number],$N$1),"")
However, I am copying from another table called 'TBLACTeam' - specifically a percentage.
I am trying to get a formula that will give me a specific value from TBLACTeam, for a specific week and for a specific player onto a separate worksheet
I have had no success with: =IF(O3>0,SUM(TBLACTeam[A:C TD],TBLACTeam[Player],$N3,TBLACTeam[Week number],$N$1))
Can anyone help me out?
Really appreciate this as this would massively my Sport Science Manager out.
Thank you
Lewis
