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.
