S
Sorin
A previous PM set up a Microsoft project plan and used a customized field to
display an alert when the progress on a task was falling behind. I would
like to extend that code to display a gold star symbol when the task comes in
ahead of schedule.
I understand basically how the code is written, however not well enough to
get it to work properly. I was hoping you could help me???
We are using IIf( expr, truepart, falsepart )on a customized field "Alert"
[Date1] = now
[Start] = start date on plan
[Finish] = deadline on plan
[Number3] = tolerance set to 0
25 displays Red Dot graphical indicator
30 displays Yellow Dot graphical indicator
35 to display Gold Star (not available, I'll need to import it in, not sure
how yet)
Current Code:
IIf(([Date1]>[Start]) And
([Date1]<[Finish]),IIf(([Date1]-[Start])/([Finish]-[Start])*100>([%
Complete]+[Number3]),25,0),IIf(([Finish]<[Date1]) And ([%
Complete]<100),30,0))
Need to Add this Code:
IIF(([Finish]>[Date1]) And ([% Complete]=100),35,0)
Thank you!
display an alert when the progress on a task was falling behind. I would
like to extend that code to display a gold star symbol when the task comes in
ahead of schedule.
I understand basically how the code is written, however not well enough to
get it to work properly. I was hoping you could help me???
We are using IIf( expr, truepart, falsepart )on a customized field "Alert"
[Date1] = now
[Start] = start date on plan
[Finish] = deadline on plan
[Number3] = tolerance set to 0
25 displays Red Dot graphical indicator
30 displays Yellow Dot graphical indicator
35 to display Gold Star (not available, I'll need to import it in, not sure
how yet)
Current Code:
IIf(([Date1]>[Start]) And
([Date1]<[Finish]),IIf(([Date1]-[Start])/([Finish]-[Start])*100>([%
Complete]+[Number3]),25,0),IIf(([Finish]<[Date1]) And ([%
Complete]<100),30,0))
Need to Add this Code:
IIF(([Finish]>[Date1]) And ([% Complete]=100),35,0)
Thank you!