TheTrickster wrote:For any leagues where teams can trade draft picks, is there a way to edit the formulas for the team rosters to direct them to look at different cells?
For example if Team 5 actually had the first pick in Round 3, is there a way to tell the roster stats page to look to cell B1327 rather than F1327 for their third pick?
Your Excel skills are over my head and I couldn't figure out how to do it myself. I don't mind if it's tedious, but since I couldn't figure out how it worked I wasn't sure if it was even possible.
The way it is setup, you would just enter the pick for the teams in order. In other words, if Team 5 has the first pick in round 3, you would just enter Team 5's pick in the Team 5 slot for round 3. The Roster Stats page lists all of the team's picks in the order they are entered on the draft sheet.