Feb 03 2023 12:50 AM
I have 2 share point lists which I am trying to get to interact with each other to see capacity of people.
the first list is a list of projects with day count estimates for a project manager, business analyst and tester and a start and end date of the project. Also on this list is a people column for the specific Project Manager, Business Analyst and Tester (once they are assigned)
the second list is the list of specific project managers, business analysts and testers and their total available days per month.
I would like the first list to recognise where the pm, BA and testers are over capacity if they are assigned to another project which exceeds their available days per month based on the start and end date.
is this possible to achieve ?
Feb 06 2023 07:50 AM
Feb 07 2023 02:31 AM
thank you - do you know what formulas I would use to achieve this?