coolguykets1
Board Regular
- Joined
- Feb 6, 2013
- Messages
- 94
I have below column hedaers from BK11 to BZ11. These are basically steps in my projects.
I have a drop down in AW11 which i basically update once the status changes of a particluar project. I have 10000+ such project with each row as 1 project.
I want to basically track dates for each step. So if i choose today 1st Header data in AW11=OE Samples Procurement then it should populate today date for that row in OE Sample Procurement. If in 2 days i choose next steps as OE Sample Procure. Eval in progress which is second step then it should keep todays date in previous step and add date at that day when i chose the nxt step to that step. If i jump to directlly 3rd step then it should automatically type current dates for all the 3 steps.
<tbody>
</tbody>
I have a drop down in AW11 which i basically update once the status changes of a particluar project. I have 10000+ such project with each row as 1 project.
I want to basically track dates for each step. So if i choose today 1st Header data in AW11=OE Samples Procurement then it should populate today date for that row in OE Sample Procurement. If in 2 days i choose next steps as OE Sample Procure. Eval in progress which is second step then it should keep todays date in previous step and add date at that day when i chose the nxt step to that step. If i jump to directlly 3rd step then it should automatically type current dates for all the 3 steps.
OE Sample Procurement | OE Sample Producred. Eval in progress | Engg ok for PF to Quote | Quote Received | PM Review and Quote Accepted. PF to get Tech Package | Technical Pacakge Received. Engg Release in Progress | Engg Release Completed. For OMS Setup | Soms Setup/costing Completed | EDC - Date Orders Placed | Final PPAP Submission | PPAP Approved | Orders Due | EDC Received Initial Stocking | CM - Part Made Saleable in Soms | Pricing | Available in Catalog |
<tbody>
</tbody>