Project phase formula

[dchatrie]

I am trying to create a template and i would like help on a formula, I would like a formula to choose the phase a project, so if the initiation phase is complete the formula should show that its in the next phase for example planning, and if both are completed it should show the next phase as so on.

Thank you

 

[Sajan]

Will you have data indicating the percentage completion for each phase?
What are the phases you are tracking?

 

[dchatrie]

Yes I will, Please see attached a sample of my workbook.

Thanks for any assistance that you can give.

 

[dchatrie]

I am basically saying once one phase is completed I would like the phase to reflect the next one.

 

[SirJB7]

Hi, dchatrie!

First of all you have a circular reference at cell F15:
=IF(ISBLANK(E15)=TRUE,(D15-C15)/($F$15-$F$10),(E15-C15)/($F$15-$F$10))

Despite of this you could try this formula:
=SI.ERROR(INDICE(B11:B16;CONTARA(E11:E16)+1);"Game over") -----> in english: =IFERROR(INDEX(B11:B16,COUNTA(E11:E16)+1),"Game over")

Regards!

 

[dchatrie]

Thank you, it worked.

Regards

 

[SirJB7]

Hi, dchatrie!
Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.
Regards!

 

[dchatrie]

I have an addition to this formula I would like to make, I would like the formula to not only read the next stage but once the stage/phase is not completed I would like the formula to pick it up. I have attached the worked of what i am trying to attempt.

Thank you for any assistance that you can give.

 

[Sajan]

Hello,
Try the following array formula:
=TEXT(INDEX($B$7:$B$16, MATCH(TRUE, $B$7:$B$16<1,0)), "0%") & " " & INDEX($A$7:$A$16, MATCH(TRUE, $B$7:$B$16<1,0))

enter with Ctrl + Shift + Enter.

Cheers,
Sajan.