Formula Issues

G

gochberg

I am trying to create an Enterprise Task Text formula that represents
each task in a Recruiting process. I want it to go in this order:

If the task is going to be late, go Red
If the task is complete, go Green
If the task has not started, but was not expected to have been started
yet, go white
If the task has started on time, but is not yet complete or late, go
Blue

My formula is:
IIf([Finish Variance]>0,1,IIf([% Complete]=100,2,IIf([%
Complete]=0,3,IIf([% Complete]>0,4))))

The 1,2,3,4 map to their respective graphical indicators.

Baselines have been performed

The problem is that if a task has not started, none of the indicators
work. This is especially an issue if a task has not started and it has
missed its date, as there would be no indication.

I have also tried using fields that used [Current Date]>[Baseline
Start] AND [Actual Work]=0 to show that a task that should have started
has not to represent a 5th indicatorand that does not seem to work
either. See below:

IIf([Finish Variance]>0,1,IIf([% Complete]=100,2,IIf([%
Complete]=0,3,IIf([Current Date]>[Baseline Start] And [Actual
Work]=0,4,IIf([% Complete]>0,5)))))

I would appreciate any suggestions.
 
E

Ehsan Khan

Dear,

You can use the following formula for your use.... make any alterations
based on the color code.......

IIf([%Complete]=100,IIf([Finish Variance]>0,â€Late
Completionâ€,â€Completedâ€),IIf(ProjDateDiff([Current Date],[Baseline
Start])/480>0 AND [%Complete]=0,â€Not Startedâ€,IIf(ProjDateDiff([Baseline
Finish],[Current Date])/480>0,â€Lateâ€,â€On Timeâ€)))

Equals ‘Late : “Red Ballâ€
Equals ‘On Time’ : “Yellow Ballâ€
Equals ‘Completed’: “Green Ballâ€
Equals ‘Not Started’: “White Ballâ€
Equals ‘Late Completion’: “Black Ballâ€

Hope this helps......
 
G

gochberg

Thanks. I am away from the environment today, but I willl try it
Monday. It makes sense to me. Very much appreciated!
 
Top