I'm currently making a premier league table with random teams in a google doc. I have majority of the work done but I cannot think of a solution to the form slot.
league table.png
As shown in the picture above the Form part shows the last 5 results of that team. I cannot for the life of me figure out a solution on how to display this via formula. If anyone has any ideas that would be a great help. I've made a mock up google sheet of made up team names that could help figure it out. Normally the columns C, D, E would show as hidden as they are just to sort a position order.
Thanks.
Never mind it doesn't let me post URLS until I've posted a few times. Not sure of a solution to that either.
This is my solution to it, sorry if its not allowed.
url.png
Bookmarks