We are trying to define roles and responsibilities within our organisation. One of the possible models that works really well in Excel is the Responsibility assignment matrix or RACI model. See https://racichart.org/
It is basically a table with tasks as rows and roles as columns and in each cell a marker that defines if someone is Responsible, Accountable, Consulted or Informed (hence RACI) by sdding a letter in a cell. When this table is filled in properly we can give each employee a clear overview of his/her responsibilities.
Im getting the hang a bit of Airtable and am able to use it for a lot of our organisational overviews, but I have no clue yet if the above mentioned could also be achieved with Airtable and lead to a satisfying result, or if I should just stick to Excel for this. Would be awesome to hear your suggestions!
I’m interested in this too…hoping to see some responses from some Airtable whizzes. My org has expanded our project management system on the whole and we’re using RACI charts in launching new projects (among other tools).