I am really enjoying Coda, and can’t wait to see what the future holds. One item I would appreciate insight on is how to create a head to head win/loss table in Coda (i.e. show each team’s record vs each other team). In Excel/Sheets, this was quite simple; you would list all the teams in one column, and then list them again along the top row. You could then fill in the corresponding records, and have a table that looks like this:
This is certainly doable in Coda, but my approach feels quite clunky and much less useful then on these other platforms. For clarity, each Team’s schedule and results are contained in other tables, so the need to reference each team to automatically fill-in records is critical.
One approach I tried was having Teams in a single column and again the column names for the other rows, but this is not ideal, since I will typically want to reference a Team to dynamically generate this data, and having it as a column name makes that difficult (no INDIRECT function equivalent).
Another approach is similar to the one above, but having the Teams along the top listed in the first row, as seen below. The problem here is that Coda does not operate on a cell basis, so trying to reference these Teams to generate the data would be less than ideal.
One viable option is to list every opponent for each team as the row items, then had a second column for the Record. This works for making the calculations, although it is not as pretty to look at:
There are table-less approaches, but those don’t quite hit what I am envisioning, as ideally you would see each team’s record against each other team in a tabular format.
Building one-off examples manually is fine, but if everything is to be dynamic (e.g. different people could have different leagues with different Team names), then balancing UI and with the ability to calculate is tricky. Appreciate any insights, ideas, or approaches.