In the attached file, in the TechDev tab, I have the resources names and the status of the projects they own. Than to the far right, all the milestones that align with each project - planned and actual (2 columns per milestone). In the Workload tab, I want to be able to do the following:
1. Under the Past Due column per milestone, count how many milestones are past due based on TODAY, where resource is Resource 1 (or 2, 3, so on) and status is In Progress
2. In the Due In column per milestone, although a count is fine, I was wondering if a formula can quantify how many days more before it is actually past due using the Planned column.
Thx
Bookmarks