Automatic transfer of data

[Novicesportsperformer]

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

 

[Novicesportsperformer]

Don't Worry I figured it out