Any help graciously accepted here!.
I am aiming to create a resource forecasting schedule. I have 2 datasets to compare and condition.
List 1 is a list of individual tasks that have different people assigned as competent to carry out these tasks and thus are available for selection.
List 2
An absence list containing the names of those who are on leave in the upcoming date range.
Ideally, I'd like to have a dropdown list in a separate third table allowing only those in table 1 who are available for the unique tasks and not on holiday in list 2 on the certain day.
So for task 1 on 21/10/2019 (highlighted green) the resulting dropdown would provide only options for Matthew and John because Cain, Able, Joseph and Mary are on holiday. Not sure how the blanks factor into this or how to eliminate those that are in both datasets either.
I'm a relative novice here so I have no idea if this can be done but it would be of great benefit if possible. Thanks for reading.
I am aiming to create a resource forecasting schedule. I have 2 datasets to compare and condition.
List 1 is a list of individual tasks that have different people assigned as competent to carry out these tasks and thus are available for selection.
List 2
An absence list containing the names of those who are on leave in the upcoming date range.
Ideally, I'd like to have a dropdown list in a separate third table allowing only those in table 1 who are available for the unique tasks and not on holiday in list 2 on the certain day.
So for task 1 on 21/10/2019 (highlighted green) the resulting dropdown would provide only options for Matthew and John because Cain, Able, Joseph and Mary are on holiday. Not sure how the blanks factor into this or how to eliminate those that are in both datasets either.
I'm a relative novice here so I have no idea if this can be done but it would be of great benefit if possible. Thanks for reading.