Jun 02 2022 06:17 AM
I am trying to build a tracker that show where my project is in the process (task & dates- created/assigned/ready ) the issue i am having is that my data dump file that shows the task status has duplicate job IDs and i cant use a vlookup i tried. i thought i had it working with a vlookup but when a resorted the data dump it didnt work anymore. Here is what i am trying to do -- lookup my job id on Main Tracker Search for it on the Data Dump tab - pull in the data to my tracker.
Main tracker - (showing only one task)i made up the data i am trying to pull in on the my tracker)
Request/Job | Survey Created Date | Survey Status | Survey Assigned Date | Survey Accepted Date | Survey Ready for Approval Date | Survey Approved Date | Survey Task Due Date | Survey Scheduled Date | Survey Status |
JB0000812941 | 9/5/1999 | Task Not Required | |||||||
JB0000967144 | 2/1/2021 | Approved | 4/15/2022 | ||||||
JB0000954107 | |||||||||
JB0000855353 |
Data Dump File
Request/Job | Job Descr | Task Name2 | Job Owner Name2 | Status Of Task Code | Created Date2 | Assigned Date2 | Accepted Date2 | Ready for Approval Date2 | Approved Date2 | Task Due Date2 | Scheduled Date2 |
JB0000426143 | COEPA | Address Mismatch Validation | SD | Task Not Required | 8/13/2020 | ||||||
JB0000426143 | COEPA | Capacity Verify | SD | Task Not Required | 8/13/2020 | ||||||
JB0000426143 | COEPA | Coax Activation | SD | Task Not Required | 8/13/2020 | 1/5/2022 | 1/28/2022 | 2/25/2022 | |||
JB0000426143 | COEPA | Coax Construction | SD | Task Not Required | 8/13/2020 | ||||||
JB0000426143 | COEPA | Determine Permits | SD | Task Not Required | 8/13/2020 | ||||||
JB0000426143 | COEPA | Evaluate Constructed Items | SD | Task Not Required | 2/16/2022 | ||||||
JB0000426143 | COEPA | Evaluate Estimates | SD | Task Not Required | 2/16/2022 | ||||||
JB0000426143 | COEPA | Fiber Activation | SD | Task Not Required | 8/13/2020 | 1/5/2022 | 1/28/2022 | 2/25/2022 | |||
JB0000426143 | COEPA | Fiber Construction | SD | Task Not Required | 8/13/2020 | ||||||
JB0000426143 | COEPA | Headend Design | SD | Task Not Required | 8/13/2020 | ||||||
JB0000426143 | COEPA | Headend Ready | SD | Task Not Required | 8/13/2020 | ||||||
JB0000426143 | COEPA | Survey | SD | Task Not Required | 2/16/2022 | ||||||
JB0000426143 | COEPA | Install Nodes COEPA | SD | Task Not Required | 1/5/2022 | 1/5/2022 | 1/28/2022 | 2/25/2022 | |||
JB0000426143 | COEPA | Optimize Nodes | SD | Task Not Required | 8/13/2020 | 1/5/2022 | 2/25/2022 | ||||