This is great Dave thanks so much! How would I filter ranking a specific date so I don’t have my fastest athlete taking up a majority of the top spots? Thanks in advance!
I wanted a leaderboard for all athletes each time we test, regardless of sport, so I followed this video but changed the team dropdown menu to a menu of testing dates and that worked for me. I also added a condition to the formula to get only M or F for two different leaderboards. If you want team and date, I think you can just add another condition to the formula with a drop-down of testing dates. Even if kids miss the actual testing date, I put the date the same as the others to capture each time point as opposed to a specific day.
"I'm working on creating a leaderboard on Google Sheets with multiple testing dates. I've run into an issue where the same person is ranked multiple times because they're the strongest on the bench or whatever is being tested . Do you have any suggestions on how to modify the ranking formula to ensure only the highest score is considered for each athlete? Thanks for your help!
I'm working on creating a leaderboard on Google Sheets with multiple testing dates. I've run into an issue where the same person is ranked multiple times because they're the strongest on the bench (etc). Do you have any suggestions on how to modify the ranking formula to ensure only the highest score is considered for each athlete? Thanks for your help!"
What if I want to rank all athletes regardless of sport? Because with the tutorial, you can only rank per sport. How to have an option to rank overall?
This is great Dave thanks so much!
How would I filter ranking a specific date so I don’t have my fastest athlete taking up a majority of the top spots?
Thanks in advance!
that is quite a bit more complicated to do..
I wanted a leaderboard for all athletes each time we test, regardless of sport, so I followed this video but changed the team dropdown menu to a menu of testing dates and that worked for me. I also added a condition to the formula to get only M or F for two different leaderboards.
If you want team and date, I think you can just add another condition to the formula with a drop-down of testing dates. Even if kids miss the actual testing date, I put the date the same as the others to capture each time point as opposed to a specific day.
"I'm working on creating a leaderboard on Google Sheets with multiple testing dates. I've run into an issue where the same person is ranked multiple times because they're the strongest on the bench or whatever is being tested . Do you have any suggestions on how to modify the ranking formula to ensure only the highest score is considered for each athlete? Thanks for your help!
I'm working on creating a leaderboard on Google Sheets with multiple testing dates. I've run into an issue where the same person is ranked multiple times because they're the strongest on the bench (etc). Do you have any suggestions on how to modify the ranking formula to ensure only the highest score is considered for each athlete? Thanks for your help!"
What if I want to rank all athletes regardless of sport? Because with the tutorial, you can only rank per sport. How to have an option to rank overall?