Ah, the spreadsheet metaphor: Airtable’s strength and weakness.
A good rule of thumb is that when you look at a table in a grid view — the one that looks most like a spreadsheet — the only calculations you can perform must use values along a horizontal line. To perform any math or comparisons against values arrayed vertically, you must link the records (the horizontally oriented values) to a record in another table and use this linked record as a point from which to gather and consolidate values from other records.
For instance, in your example above, you might easily have individual tables named [Name], [Project], [Labor], and———
Wait: Take a look here. I copy-and-pasted the four columns of data (Donald through Doris through ‘Wed, Thu, Fri’) into an Airtable table, converted {Project} and {DoW} from single-line text to linked-record fields (creating the linked tables and automatically generating the linked records), and tossed together a few rollup fields to perform some of the consolidating math. (I didn’t do a cost per DoW per project, because I’d need to change the base structure a bit, and I don’t really wantto get neck deep in an illustration.)
That’s a bare-boned base, but you should be able to build upon it to achieve the sort of functionality you outline above. Will it be as easy as working in Excel’s two-dimensional matrix? No. Will you be able to accomplish things you can’t do in Excel? Yes. Do you need to accomplish such things? I don’t know; only you can answer that question. Airtable, like any tool, isn’t the right choice for every application; this may be one of them. However, if it is the right choice, Excel isn’t. :winking_face:
