I’m working right now on that exact same problem And I’m a Coda enthusiast, so I’m going to talk to you about the way of the thinking and the rationale, rather than the technical solution. So, IMHO, Coda has, basically, no limits when it gets to the model. And DB, rather than tables, is actually the proper way to think.
Now limitations comes mostly from the display (and then later with the interactions). In your example, you want to display weeks as columns. But before jumping into how doing this easily, you have to open a bit more your mind and stick to the “problem space” a bit longer, rather than jumping into the “solution space” too soon. So … you want to display the workload of your talents, and you need to see this week by week. But maybe weeks won’t de displayed as columns, and if it still solves the problem, that would be perfectly acceptable, right? Going back to DB. Would you add a column for each week in your DB? I think you wouldn’t, you would create a second table with weeks as lines, and cross-reference talents loads with week numbers. That would be the exact same way you would go in Coda.
And then, back to the solution space. Now that the model is defined in a very clean and neat way (just as a DB), you’re going to work on displaying this in a fashion you fancy. This is where things get a bit more tricky, because now you need to know exactly what Coda can and can’t do. And that takes a bit of time. For your specific example, there are 2 tricks you want to know:
- you will use many different views of the same table, and add columns to these views dedicated to displaying this view correctly rather than enhancing your model. Most of theses columns will contain formulas and will be hidden.
- you will “group by” with a “top” display, to mimick columns
And so, with these 2 tricks, you can create a view on your big table, and reach the solution you’re looking for. Or another one, because most of the time, you tend landing in another place, as good or even better as the one you were aiming for initially.
Hope this helps