I have two tabs in my excel sheet.
Tab 1: Contains a list of all the dependencies across multiple functional area. The columns are functional area, dependency description, dependency id, plan end date, target end date.
Tab 2: Contains a list of tasks with the following columns: Functional area, Deliverable name, deliverable description, Target Date, projected date, Dependencies ID
E.g.
Functional Area Dependencies Plan end date Target End date
F1 D1 8/22 8/22
F1 D2 8/23 8/23
F2 D3 8/24 8/24
F2 D4 8/25 8/25
Functional Area Deliverable Dependencies Target Date Projected Date
F1 de1 D1, D2 8/20
F1 de2 D1 8/20
F2 de3 D3, D4 8/20
F2 de4 D3 8/20
The Dependencies ID will contain all the IDs tied to a given deliverable from tab 1. The help I want is a way to find out that if any of my dependencies tied to a given deliverable have a date past the targeted date of my deliverable, my projected date should be populated to the latest date among all the dependencies. So in the above example, projected date for de1 should be populated to 8/23 and projected date for d2 should be 8/22. Please advise. Thank you.
Tab 1: Contains a list of all the dependencies across multiple functional area. The columns are functional area, dependency description, dependency id, plan end date, target end date.
Tab 2: Contains a list of tasks with the following columns: Functional area, Deliverable name, deliverable description, Target Date, projected date, Dependencies ID
E.g.
Functional Area Dependencies Plan end date Target End date
F1 D1 8/22 8/22
F1 D2 8/23 8/23
F2 D3 8/24 8/24
F2 D4 8/25 8/25
Functional Area Deliverable Dependencies Target Date Projected Date
F1 de1 D1, D2 8/20
F1 de2 D1 8/20
F2 de3 D3, D4 8/20
F2 de4 D3 8/20
The Dependencies ID will contain all the IDs tied to a given deliverable from tab 1. The help I want is a way to find out that if any of my dependencies tied to a given deliverable have a date past the targeted date of my deliverable, my projected date should be populated to the latest date among all the dependencies. So in the above example, projected date for de1 should be populated to 8/23 and projected date for d2 should be 8/22. Please advise. Thank you.
