If Condition

[adcz250]

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>
[TD="width: 9%, bgcolor: #c0c0c0"]

Email Sent​

​

​

​

​

​

[/TD]
[TD="width: 9%, bgcolor: #c0c0c0"]

No of Days Outstanding​

​

​

​

​

​

[/TD]
[TD="width: 9%, bgcolor: #c0c0c0"]

Lead Response​

​

​

​

​

​

[/TD]
[TD="width: 9%, bgcolor: #c0c0c0"]

Triage Complete​

​

​

​

​

​

[/TD]
[TD="width: 9%, bgcolor: #c0c0c0"]

Review Complete​

​

​

​

​

​

[/TD]
[TD="width: 10%, bgcolor: #c0c0c0"]

Awaiting further information​

​

​

​

​

​

[/TD]
[TD="width: 14%, bgcolor: #c0c0c0"]

Awaiting design team/business Triage​

​

​

​

​

​

[/TD]
[TD="width: 10%, bgcolor: #c0c0c0"]

Awaiting workstream lead review​

​

​

​

​

​

[/TD]
[TD="width: 11%, bgcolor: #c0c0c0"]

Awaiting RDA presentation​

​

​

​

​

​

[/TD]
[TD="width: 12%, bgcolor: #c0c0c0"]

Status​

​

​

​

​

​

[/TD]

[TD="width: 9%"]

15/07/2013​

​

​

​

​

[/TD]
[TD="width: 9%"]

16​

​

​

​

​

[/TD]
[TD="width: 9%"][/TD]
[TD="width: 9%"][/TD]
[TD="width: 9%"][/TD]
[TD="width: 10%"][/TD]
[TD="width: 14%"][/TD]
[TD="width: 10%"][/TD]
[TD="width: 11%"][/TD]
[TD="width: 12%"] Awaiting Response
[/TD]

</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

 

[chataylo]

I don't see L8 referenced in your formula and isn't your formula posted in column L?

 

[sdsurzh]

Hi,

Can you please try this (i am not sure this is correct)

=IF(L8="","",IF(L8="",IF(H8="",IF(G8="",IF(F8="",IF(I8="",IF(J8="",IF(K8="",IF(D8="","Awaiting Response"),"Awaiting Workstream Lead Review"),"Awaiting Design Team / Business Traige"),"Awaiting for Further Information"),"Response Received"),"Triage Complete"),"Review Complete"),"Yet to start"))

Thanks,
SK

 

[adcz250]

Hello,

I still can not get "Awaiting RDA presentation".. with reference:L8

=IF(H8="",IF(L8="",IF(G8="",IF(F8="",IF(I8="",IF(J8="",IF(K8="",IF(D8="",IF(P8="","","Yet to Start"),"Awaiting Response"),"Awaiting RDA presentation"),"Awaiting Workstream Lead Review"),"Awaiting Design Team / Business Traige"),"Awaiting for Further Information"),"Response Received"),"Triage Complete"),"Review Complete").............

..All If formula work....

 

[chataylo]

I believe the problem is the order. What order will things be done? (Just type the titles from table in right order and I will see if I can get a proper if then statement)

 

[adcz250]

If I Enter :
Date in D8 = Awaiting Response
F8= Response Received
G8 = Triage Complete
H8 = Review Complete
I8 = Awaiting further information
J8= Awaiting design team/business Triage
K8:= Awaiting workstream lead review
L8= Awaiting RDA presentation

The only problem is in L8
If I enter in anything in P8 = Yet to Start

 

[chataylo]

I have values in row two, but this equation worked for me. The only thing I see is that you have D2 filled out so its stopping there. Delete the email sent date and the equation works.

=IF(D2 = "",IF(F2="",IF(G2="",IF(H2="",IF(I2="",IF(J2="",IF(K2="",IF(L2="",IF(P2="","","Yet To Start"),"Awaiting RDA Presentation"),"Awaiting WorkStream Lead Review"),"Awaiting design team/business Triage"),"Awaiting further information"),"Review Complete"),"Triage Complete"),"Response Received"),"Awaiting Response")

 

[adcz250]

Thanks chataylo...



it's working now..However I also need this data so that I can records when email has been sent.is there anyway we can keep D2 and still formula work.

 

[chataylo]

Yes, but I can't exactly do it for you, because I don't understand what exactly is going on. Excel reads to formula from outside in, so the reason you can't have D2 and get the response you want is that D2 is used in the first if then statement. You can either delete this if then statement, change the order, or you could add and statements that would allow you to say if D2="" and F2 ="" then "What ever you want" will be displayed.

The proper format is And(D2="",F2="")

I hope that allows you to solve it, but if not just reply and i'll see what i can do.

=IF(D2 = "",IF(F2="",IF(G2="",IF(H2="",IF(I2="",IF(J2="",IF(K2="",IF(L2="",IF(P2="","","Yet To Start"),"Awaiting RDA Presentation"),"Awaiting WorkStream Lead Review"),"Awaiting design team/business Triage"),"Awaiting further information"),"Review Complete"),"Triage Complete"),"Response Received"),"Awaiting Response")

 

[adcz250]

Hello,

This is my Final Column


[TABLE="width: 800"]
<TBODY>[TR]
[TD]Email Sent</SPAN>
[/TD]
[TD]No of Days Outstanding</SPAN>
[/TD]
[TD]Lead Response</SPAN>
[/TD]
[TD]Triage Complete</SPAN>
[/TD]
[TD]Awaiting further information</SPAN>
[/TD]
[TD]Awaiting design team/business Triage</SPAN>
[/TD]
[TD]Awaiting workstream lead review</SPAN>
[/TD]
[TD]Awaiting RDA presentation</SPAN>
[/TD]
[TD]Review Complete</SPAN>
[/TD]
[TD]Status</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]06/08/2013</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Awaiting Response</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]


Sorry I am new to the excel,,, Can Someone please assist My Final Formula is : =IF(L2="",IF(K2="",IF(J2="",IF(I2="",IF(H2="",IF(G2="",IF(F2="",IF(D2="",IF(P2="","","Yet to Start"),"Awaiting Response"),"Response Received"),"Triage Complete"),"Awaiting further information"),"Awaiting design team/business Triage"),"Awaiting workstream lead review"),"Awaiting RDA presentation"),"Review Complete").

Still I am getting an error message for k Column : I need "Awaiting RDA presentation" in K Column if I enter Date