Wanted to throw an idea out for the new trade block tab on the Google sheet. Boxy and BTS changed their link to a named hyperlink (=HYPERLINK("link address here","Trade Block"). Good idea, pretty's it up instead of some rando web address.
Got me thinking, do we need a column for the link, or do we just make the Organization name the link with the text of the hyperlink the team name (which is referenced from the 'Teams' tab in case of team name change). I did this so everyone could see how they like it, easy to change back if people don't.
That got me thinking again, do we even need another tab on the spreadsheet, or do I just change the team names on the 'Prospects & Picks' tabs and the 'Rosters' tabs to be the link to the trade blocks? Only information lost is how recently the block was update, which is information that really should be on the individual trade sheets themselves. The way we have it set up now, an admin would have to update the 'last modified' cell for those who don't have editing access to the doc.
I edited my name in the prospects & roster tabs to a hyperlink, so people can see what it would look/function like.
Let me know what you all think.