Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to calculate and show daily workload

Topic Labels: Formulas
1135 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: