In my table, I have many projects inserted as different records in a column. In another column, I included the project lead for each project, and in a third column are other staff members working on each project but are not project leads.
I want to create a block or a column showing an individual’s weekly or monthly workload. For example, if Mark is a project lead to 3 projects but also working on 2 projects that are led by someone else, I would like to have a place where I can see his whole workload for the month. Does anyone have any suggestions?
Thanks in advance