Google Sheets Athlete Wellness Monitoring Dashboard | Part 2 | Creating Your Dataset

In this video we start a new series on how to create this athlete workload monitoring dashboard in google sheets. We will work on creating our dataset and entering formula that will autmatically calculate all the way down when we enter in the values.
► Support DSMStrength HERE: www.buymeacoffee.com/DSMStrength
►Purchase The Athlete Dashboard HERE: tinyurl.com/DSMLTDash
SUBSCRIBE TO DSMSTRENGTH: bit.ly/3xRrNH7
[Books I Love] Support the Channel
►Periodization: amzn.to/2mOiBDA
►Strength Coach Guide to Excel amzn.to/2xAEZ4p
►Strength Coach Playbook: amzn.to/2mY9crI
►Principles and Practice of Resistance Training: amzn.to/2mM1Jf6
►High Performance Training for Sport: amzn.to/2mqWb74
[Connect with Me]
►See all Strength Coach Tutorials: bit.ly/2mLU5Bf
►Check our website: www.dsmstrength.com
[Social Media]
►Instagram: / dsmstrength
►Twitter: / dsmstrength
►Facebook Page: / dsmstrength

[@FabrizioNicosia]

Another great content, tnx

[@DSMStrength]

thanks for the comment that helps the channel out a bunch!

[@liamallison7722]

Excellent work, love the video- when is the next one releasing?

[@DSMStrength]

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!

[@charliecerny6606]

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?

[@ruifernandes6336]

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?

[@louismitchell9015]

How can get the dates be 7 days apart ? for monitoring once a week

[@samuelthorley9547]

In this context what does inactive mean?

[@TeamMcMillian]

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!

[@DSMStrength]

Delete the formulas below it

[@TeamMcMillian]

@@DSMStrength Thank you!

[@DSMStrength]

@@TeamMcMillian the errors generally tell you what the problem is

[@hernanzocchi]

@@DSMStrength =ARRAYFORMULA(IF(A2:A "", MMULT(D2:G*1, TRANSPOSE(D2:G2*0)), "")) IT GIVES ME A RESULT 0