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% cmpl = 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.

Thanks

In a text field:

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")

Thank you for your response. It is much appreciated

Hi,

This formula works great but I need a slight change.

It is possible for the formula to be amended so that if the task name equals "xxx" it will leave the output blank (i.e. not red, amber. etc.)

Any help would be appreciated.

Regards

Planner18

Apologies to Julie for taking this one on <g>... To keep it simple, try tis one.

IIf([Name]<>"xxx",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"),"")

It is the same as the original with a small section before AND after the previous formula, which should be easy to follow.

Hi Guloluseus,

Sorry to say it didn't work

It turned all the indicators to red but it did remove the indicator with the text name 'xxx'.

Regards

Planner18

I tried the formula on my copy of MSP 10, and it worked fine, then copied and pasted into the post, so it SHOULD work. Did you copy and paste it into the equation box in MSP, or type it manually? If it was typed, try pasting it straight in, that my solve it.

I will try on another computer and see what happens, have known these to work fine on one and not another!

Hi Guloluseus,

I have copied and pasted and the formula works fine.

Thank you very much for all your help.

Regards

Planner18

Glad it worked

Itsvery easy to mistype, especially with commas and brackets everywhere!