I am trying to create a fluid document that ranks teams by their current total number of points. The image below shows how I have it set up in the spreadsheet. Currently, as teams score points they are automatically updated next to their team name. What I would like is for the Team name with the most points at any given moment be shown in first place in column F (F2). And then have the sheet rank each of the teams and populate the appropriate cell in column F. Is this possible?