Liam Thanks so much for watching!! I can't keep up with how fast you are taking in this content lol! I am on a weekly schedule right now for my video releases, try to get the new one out every monday!
Is there any way to do this same thing, but have information from other Google Sheet files being updated and pulled into one database? For example, each athlete has their own excel file but I want to be able to pull the data from each file and have it continuously update in the main database file?
this formula to give the score "readiness" "=arrayformula(IF(A2:A"";MMULT(D2:G*1;TRANSPOSE(D2:G2^0));""))". I need to use it for calculate the multiplication of training load and training session duration to give me training load. How can I do it?
When I get to the 10:26 mark and am adding the arrayformula =arrayformula(if(A2:A "", if(vlookup(A2:A, 'Athlete Info'!A:J, 10, false) = false, "", TRUE), "")) I keep getting #REF! error saying array result was not expanded because it would overwrite data in C3. Could you tell what I might be doing wrong? Thank you for all your content you put out!
Excellent work, love the video- when is the next one releasing?
Liam Thanks so much for watching!! I can't keep up with how fast you are taking in this content lol!
I am on a weekly schedule right now for my video releases, try to get the new one out every monday!
Another great content, tnx
thanks for the comment that helps the channel out a bunch!
Is there any way to do this same thing, but have information from other Google Sheet files being updated and pulled into one database? For example, each athlete has their own excel file but I want to be able to pull the data from each file and have it continuously update in the main database file?
How can get the dates be 7 days apart ? for monitoring once a week
this formula to give the score "readiness" "=arrayformula(IF(A2:A"";MMULT(D2:G*1;TRANSPOSE(D2:G2^0));""))". I need to use it for calculate the multiplication of training load and training session duration to give me training load. How can I do it?
In this context what does inactive mean?
When I get to the 10:26 mark and am adding the arrayformula =arrayformula(if(A2:A "", if(vlookup(A2:A, 'Athlete Info'!A:J, 10, false) = false, "", TRUE), "")) I keep getting #REF! error saying array result was not expanded because it would overwrite data in C3. Could you tell what I might be doing wrong? Thank you for all your content you put out!
Delete the formulas below it
@@DSMStrength Thank you!
@@TeamMcMillian the errors generally tell you what the problem is
@@DSMStrength =ARRAYFORMULA(IF(A2:A "", MMULT(D2:G*1, TRANSPOSE(D2:G2*0)), "")) IT GIVES ME A RESULT 0