Hello,
I have a dashboard that I am creating that works like this:
User selects a program, and that populates a table below.
User then selects the Title field, and that populates another table above based on a specific value. This is the issue
I have a table that looks like this:
Cards | FY | Program | RFA Title | Topic Development Meeting | NPD Concept Approval | IO Notification Complete | 1st Writing Team Meeting | Final Draft to ERB Branch Chief | Final Draft to IOAA | IOAA Review Complete | Final Draft to ORM (send to OGD/OGC) |
Publish | 19 | SSWR | Harmful Algal Blooms | 3/1/2019 | 4/1/2020 | 6/1/2019 | 7/1/2019 | 8/1/2019 | 9/1/2019 | 10/1/2019 | 11/1/2019 |
Baseline | | SSWR | Harmful Algal Blooms | 5 | 20 | 15 | 30 | 30 | 30 | 30 | 30 |
Complete | | | | x | x | x | x | x | x | | x |
Status | | AE | Chemical Mechanisms | On Time | On Time | On Time | On Time | On Time | On Time | On Time | On Time |
So what I need to do is look across Complete and find the last x which is the current status of the project, then display the RFA Title, FY, Program, Current Milestone (this is the column header name), Due Date (date that is in the Publish row), the next milestone (next column header name), and expected award which comes from a column not included in this example due to keeping data to a minimum.
I have searched high and low for every iteration of wording to find this, either by creating a temp table that stores the data for each RFA to using set analysis. Any help would be appreciated.