Automatically change Status RYGB

Adriana Herrera

Any formula to automatically change status from RYG to B once my project reached End Date?

Adriana Herrera

This is great!

Gracias! :)

RossL

@Adriana Herrera

Does the project have an end date entered before it is done?

can you share a screen shot of how the project is set up?

Adriana Herrera

Yes, END DATE is entered before action is done...

Adriana Herrera

Capture.PNG

RossL

is there something that indicates the project is complete?

Adriana Herrera

The Status Column (1) .... Which actually takes me to my next question ´cause I want a % of completion set up as well ;) But, for some reason is not showing up even if I change "project settings"

RossL

The status Column would just be a standard column added with a Text/Number column type. What are your Criteria for Red, Yellow, Green, and Blue, Statuses

Adriana Herrera

Blue: Completed

Red: Risk

Yellow: Show Stopper

Green: In progress

Is that what you need?

RossL

If you want to automate the status to go to blue the other colors will need to be called out too.

for example if % Complete = 100% Blue

IF % Complete is less than 75% and the end date is in the next 2 days, Red

IF % Complete is less than 50% and the end date is in the next 1 days, Yellow

otherwise Green

RossL

@Adriana Herrera

Here is a formula that does what I was talking about.

=IF([% Complete]@row = 1, "Blue", IF(AND([End Date]@row <= (WORKDAY(TODAY(), 1)), [% Complete]@row <= 0.5), "Yellow", IF(AND([End Date]@row <= (WORKDAY(TODAY(), 2)), [Start Date]@row <= 0.75), "Red", "Green")))

Adriana Herrera

This is great!

Gracias! :)