I’m interested in a flow by which I could track the work of teams.
First of all, I would like to have a table for employees in which it will automatically pull up:
- Their current projects
- Role on project
- Start/End project
- Their involvement (if they work for 4 hours, then it is 50%, and if 2 projects for 4 hours, then it is 100%).
- And for each employee, have his work calendar, in which it would be possible to indicate public holidays for the whole year and also be able to deliver days on vacation, sick leaves, etc.
- To show when employee get free. For example, if he has currently 2 projects, so need to choose the latest end date and then +1 day.
Also interested in the table on projects where information from the root pages will be possible to pull up into the rows.
What will be included in the list:
Name of the project
It is very important to automate all these processes in order to simplify the tracking of resources. For example, if in the developer’s calendar where his load for the entire period is shown, change the end date of the project, then in the remaining tables the project dates should also shift.
I already looked at your templates but did not find everything that I need.
I will be extremely grateful for any info that can help me achieve the desired result.