IF(H8="",IF(G8="",IF(F8="",IF(I8="",IF(J8="",IF(K8="",IF(D8="",IF(P8="","","Yet to Start"),"Awaiting Response"),"Awaiting Workstream Lead Review"),"Awaiting Design Team / Business Traige"),"Awaiting for Further Information"),"Response Received"),"Triage Complete"),"Review Complete")
D E F G H I J K L
<TBODY>
</TBODY>If I put Date in L Column: Status should change automatically to Awaiting RDA presentation. However I am getting error message. Can some advice
D E F G H I J K L
Email Sent | No of Days Outstanding | Lead Response | Triage Complete | Review Complete | Awaiting further information | Awaiting design team/business Triage | Awaiting workstream lead review | Awaiting RDA presentation | Status |
15/07/2013 | 16 | Awaiting Response |
<TBODY>
</TBODY>