This should be easy, but I suck at programming.
I am trying to setup a Team Resource planner doc.
I have one table with a bunch of tasks, planned into sprints, estimated and assigned to a team member.
Then I have another table in which I list every sprint, and the capacity for each team member that sprint.
Now I would like to add a column (“Remaining Work Days: Philip”) in the second table that shows:
- The current capacity this sprint for this member
- Minus the total estimated effort for all tasks (in the other table) that have the same Sprint Name and Team Member as this.Row
The goal is to see when I have reached the limit for each team member for each sprint.
I’d appreciate any help, and also if you have any thoughts on general improvements to the doc!