thanks @Al_Chen_Coda for taking the time, I’m a big fan of coda and thought setting up an EPL table would be a fun way to learn coda and keep track of my favorite sports league.
So I have my League Table, which is where my list of teams is and where i’m tracking points, goals for, goals against, etc.
And then everything else is getting pulled from my Master Data cause that’s where the matches, scoring, etc is housed.
I’d love to be able to automatically pull from the Master Data the next opponent for every team on the league table but not quite sure how to get there. For example the last row visible Chelsea plays Arsenal, so ideally there’s a way to show on the League Table for Chelsea that they play Arsenal and vice versa without me having to manually select the next opponent for all 20 teams each week.
Also the conditional formatting on the league table, i’d like to highlight the top 4 teams based on points as those are the teams that make the Champions League, and also the bottom 3 teams as those are the teams who would be relegated to the lower division next season. I’ve tried various methods of max or sort or nth but I can’t seem to get it right. It often will just highlight all the teams that have any points.
I have no idea if there’s a simpler/better way to be doing this project so apologies if this is a complete mess but I’m just messing around with this and trying to learn.