A Formula Request 2

[Planner18]

Hi All,

I'm looking for a formula that will change graphical indicators before 'todays date' with the following outcome.

10 days or more before todays date = green
10 to 6 days before todays date = amber
5 days or less before todays date = red
100% complete = blue.

I hope I have explained this correctly and it is not unusual request as this formula may have been provided previously.

Any help will be gratefully received.

Many thanks

 

[JulieInMaine]

What is 10 days or more before today's date - the start date? the finish date?

switch([% Complete]=100,"blue",ProjDateDiff([Current Date],[Finish])/[Minutes Per Day]<=5,"red",ProjDateDiff([Current Date],[Finish])/[Minutes Per Day]<=10,"amber",ProjDateDiff([Current Date],[Finish])/[Minutes Per Day]>10,"green")

The formula uses the finish date. It will return the words for the color - then use the graphic indicators to shows the colors based upon the text returned.

 

[Planner18]

Thank you for your response. It is much appreciated.

 

[gogglebox]

Hi Julie,

I'm new to the forum and don't know if you could help.

I have a similar request to Planner18. I need a formula to be able compare the movement of two finish dates. For example;

If task = 100% Complete then 0
If finish date is greater than finish1 date then 1
If finish date is less than finish1 date then 2
If finish date is equal to finish date then 3
If either finish date or finish1 date is 'NA' then leave blank.

I could then add indicators to show the movement.

I hope this makes sense and would be really grateful if you know the formula that could produce this outcome or point me to someone who can.

Many thanks

Gogglebox

 

[SkipVought]

HI Gogglebox,

Welcome to Tek-Tips.

What you would do here is post your question in a new thread. This thread is ONLT to address the question(s) of the original poster.

Look forward to seeing your question posted in a new thread.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[gogglebox]

Hi SkipVought,

Apologies, I was trying to keep the same theme going.

I will post a new thread.

Thanks

Gogglebox