Using graphical indicators

[bam]

Hello, I have played around a bit with the graphical indicators but am
having trouble doing the following -- it is possible?

I would like to use graphical indicators to indicate the following in a
customized field
-if task is due before today = (late) red indicator
-if task is due today or this week (week ending this Friday) = (due) yellow
indicator
-if task is due beyond Friday of this week - (scheduled) no indicator
-if a task is 100% done = (done) blue indicator

Thanks in advance for any help,

bmac

[JackD]

Yes it is possible.

You just need to create a formula in that field which will return values
that the indicator can be based on.

for example I'd use an iif statement
syntax.
iif(condition to check, value if true, value if false)

You can nest them
iif(condition to check, value if true, iif(x, y, z))

That is what you need to do here.
Something like this would work. This formula might not work because I just
made it up and haven't tested it, but it will give you a good starting
point. If it doesn't work, try out one condition at a time.

iif ([percent complete]=100,"1", iif([finish]<now(),"2",
iif([finish]<now()+5,"3","4")
--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

.

Post by bam
Hello, I have played around a bit with the graphical indicators but am
having trouble doing the following -- it is possible?
I would like to use graphical indicators to indicate the following in a
customized field
-if task is due before today = (late) red indicator
-if task is due today or this week (week ending this Friday) = (due) yellow
indicator
-if task is due beyond Friday of this week - (scheduled) no indicator
-if a task is 100% done = (done) blue indicator
Thanks in advance for any help,
bmac

[bam]

Thanks much! ... here is the formula I am using now ... and I have one more
question

IIf([%
Complete]=100,"1",IIf([Finish]<now(),"2",IIf([Finish]>now(),IIf([Finish]<now()+5,"3","4"))))



Question ...I want to trigger a graphical indicator based on a specific
date -- but I am doing something wrong -- I assume I am not using DateValue
properly ....help!



IIf([Finish]=DateValue("6/15/05"),"3","4")

Post by JackD
Yes it is possible.
You just need to create a formula in that field which will return values
that the indicator can be based on.
for example I'd use an iif statement
syntax.
iif(condition to check, value if true, value if false)
You can nest them
iif(condition to check, value if true, iif(x, y, z))
That is what you need to do here.
Something like this would work. This formula might not work because I just
made it up and haven't tested it, but it will give you a good starting
point. If it doesn't work, try out one condition at a time.
iif ([percent complete]=100,"1", iif([finish]<now(),"2",
iif([finish]<now()+5,"3","4")
--
-Jack ... For project information and macro examples visit
http://masamiki.com/project
.

Post by bam
Hello, I have played around a bit with the graphical indicators but am
having trouble doing the following -- it is possible?
I would like to use graphical indicators to indicate the following in a
customized field
-if task is due before today = (late) red indicator
-if task is due today or this week (week ending this Friday) = (due)

yellow

Post by bam
indicator
-if task is due beyond Friday of this week - (scheduled) no indicator
-if a task is 100% done = (done) blue indicator
Thanks in advance for any help,
bmac

[JackD]

I don't have project open, but I think your problem is that [finish] will
rarely (if ever) match that date value. The date value is usually 12:00AM of
the specified date. The finish is sometime between 8:00AM and 5:00PM on a
specific date if you are using the standard calendar. Only when you have a
24 hour calendar and the task happens to end exactly at that time will it
work.

To resolve this you can use datevalue of finish as well. Watch out that the
results are as you expect. You could be off by a day rather easily as the
end of the day is a different thing than the start of the day.
--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

.

Post by bam
Thanks much! ... here is the formula I am using now ... and I have one more
question
IIf([%

Complete]=100,"1",IIf([Finish]<now(),"2",IIf([Finish]>now(),IIf([Finish]<now
()+5,"3","4"))))

Post by bam
Question ...I want to trigger a graphical indicator based on a specific
date -- but I am doing something wrong -- I assume I am not using DateValue
properly ....help!
IIf([Finish]=DateValue("6/15/05"),"3","4")

Post by JackD
Yes it is possible.
You just need to create a formula in that field which will return values
that the indicator can be based on.
for example I'd use an iif statement
syntax.
iif(condition to check, value if true, value if false)
You can nest them
iif(condition to check, value if true, iif(x, y, z))
That is what you need to do here.
Something like this would work. This formula might not work because I just
made it up and haven't tested it, but it will give you a good starting
point. If it doesn't work, try out one condition at a time.
iif ([percent complete]=100,"1", iif([finish]<now(),"2",
iif([finish]<now()+5,"3","4")
--
-Jack ... For project information and macro examples visit
http://masamiki.com/project
.

Post by bam
Hello, I have played around a bit with the graphical indicators but am
having trouble doing the following -- it is possible?
I would like to use graphical indicators to indicate the following in a
customized field
-if task is due before today = (late) red indicator
-if task is due today or this week (week ending this Friday) = (due)

yellow

Post by bam
indicator
-if task is due beyond Friday of this week - (scheduled) no indicator
-if a task is 100% done = (done) blue indicator
Thanks in advance for any help,
bmac

[bam]

Thanks much. I ended up using a different function. Here is what I ended up
with.

IIf([%
Complete]=100,"1",IIf([Finish]<now(),"2",IIf([Finish]>now(),IIf([Finish]<now()+5,"3",IIf([Finish]=ProjDateValue("Wed
06/15/05 5:00 PM"),"4","5")))))

Post by JackD
I don't have project open, but I think your problem is that [finish] will
rarely (if ever) match that date value. The date value is usually 12:00AM of
the specified date. The finish is sometime between 8:00AM and 5:00PM on a
specific date if you are using the standard calendar. Only when you have a
24 hour calendar and the task happens to end exactly at that time will it
work.
To resolve this you can use datevalue of finish as well. Watch out that the
results are as you expect. You could be off by a day rather easily as the
end of the day is a different thing than the start of the day.
--
-Jack ... For project information and macro examples visit
http://masamiki.com/project
.

Post by bam
Thanks much! ... here is the formula I am using now ... and I have one

more

Post by bam
question
IIf([%

Complete]=100,"1",IIf([Finish]<now(),"2",IIf([Finish]>now(),IIf([Finish]<now
()+5,"3","4"))))

Post by bam
Question ...I want to trigger a graphical indicator based on a specific
date -- but I am doing something wrong -- I assume I am not using

DateValue

Post by bam
properly ....help!
IIf([Finish]=DateValue("6/15/05"),"3","4")

Post by JackD
Yes it is possible.
You just need to create a formula in that field which will return values
that the indicator can be based on.
for example I'd use an iif statement
syntax.
iif(condition to check, value if true, value if false)
You can nest them
iif(condition to check, value if true, iif(x, y, z))
That is what you need to do here.
Something like this would work. This formula might not work because I

just

Post by bam

Post by JackD
made it up and haven't tested it, but it will give you a good starting
point. If it doesn't work, try out one condition at a time.
iif ([percent complete]=100,"1", iif([finish]<now(),"2",
iif([finish]<now()+5,"3","4")
--
-Jack ... For project information and macro examples visit
http://masamiki.com/project
.

Post by bam
Hello, I have played around a bit with the graphical indicators but am
having trouble doing the following -- it is possible?
I would like to use graphical indicators to indicate the following in a
customized field
-if task is due before today = (late) red indicator
-if task is due today or this week (week ending this Friday) = (due)

yellow

Post by bam
indicator
-if task is due beyond Friday of this week - (scheduled) no indicator
-if a task is 100% done = (done) blue indicator
Thanks in advance for any help,
bmac