Help

How to calculate and show daily workload

Topic Labels: Formulas
1009 1
cancel
Showing results for 
Search instead for 
Did you mean: 
tommaso_1988
4 - Data Explorer
4 - Data Explorer

Hi All!
I’ll try to describe my situation.
I’ve got 3 tables: Team Members, Project and Roles.

Each role is linked to a project and a team member.
Each role contains, as information, a start date, an end date and the number of hours / day.

For example, Tommaso will be lead developer on project one from 01/03/2021 to 12/03/2021 with a with a commitment of 4 hours/day.
Tommaso will also be Sw Architect on project Two from 1/02/2021 to 4/03/2021, with a commitment of 3 hours/day.

Schermata 2021-03-02 alle 19.45.22

Here’s the question: is there a way to show the daily workload on a calendar view or a gantt view?
For each day I would like to see the sum of the H / days on the various projects, for each team member.

Something like that (even without colors).
Schermata 2021-03-02 alle 19.48.47

I hope I have explained

Thank you all!

1 Reply 1
Grunty
7 - App Architect
7 - App Architect

Sure there is a way. But in my personal opinion, your question exceeds the scope of technical inquiries this forum is intended for. In fact, it could be the matter for a small project in its own.

Here’s a hint:
In your table an important role is missing: Database Designer.
So I’d start off by adding an entry on the Projects table: Three, “Airtable development of team calendar”,
Then add a team member and assign the role: Db Designer for that project.
I think you get the idea :slightly_smiling_face: