Gérard Ducouret said:Hello Karen,
You can't show Graphical indicators on a Project's standard field such as
Status.
But you can transfer the Status values in a customized field such as
Number1, with a simple formula : [Status] that you'll find in the "Number"
Field list.
Then you'll see that:
- Complete = 0
- On Schedule = 1
- Late = 2
- Future task = 3
So it's easy to define Graphical indicators for each value
Hope this helps,
Gérard Ducouret
Karen M said:I want to create a report that shows graphical characters (Yellow, Green,
Red) using the status field. Is there a way to do this? Has anyone done
this before?
Karen M said:Gerard,
YOU ARE A GOD - do you know that you are the ONLY person who was able to
answer this question on this site when many have asked....... Thank you ever
so much
Karen
Gérard Ducouret said:Hello Karen,
You can't show Graphical indicators on a Project's standard field such as
Status.
But you can transfer the Status values in a customized field such as
Number1, with a simple formula : [Status] that you'll find in the "Number"
Field list.
Then you'll see that:
- Complete = 0
- On Schedule = 1
- Late = 2
- Future task = 3
So it's easy to define Graphical indicators for each value
Hope this helps,
Gérard Ducouret
Karen M said:I want to create a report that shows graphical characters (Yellow, Green,
Red) using the status field. Is there a way to do this? Has anyone done
this before?
Gérard Ducouret said:Hello Karen,
You can't show Graphical indicators on a Project's standard field such as
Status.
But you can transfer the Status values in a customized field such as
Number1, with a simple formula : [Status] that you'll find in the "Number"
Field list.
Then you'll see that:
- Complete = 0
- On Schedule = 1
- Late = 2
- Future task = 3
So it's easy to define Graphical indicators for each value
Hope this helps,
Gérard Ducouret
Karen M said:I want to create a report that shows graphical characters (Yellow, Green,
Red) using the status field. Is there a way to do this? Has anyone done
this before?
WHGeorge said:Gerard, I am us the flag field much in the way described (in Task Usage view)
and the problem I am have is that the Flag Field is being set to "No" for all
the resources under any particular Task, which is distracting from the Flag
itself. I have tried several variations on the IIF function to try and
elminate the No response all to no avail.
I don't know if you can nest IIF statements in Project, but one of the trys
I made looks like this:
IIf([Number20]>[Number2],Yes,IIf([Number20]=0,"",""))
What I am ultimately trying to do is simply eliminate any visible content in
the Flag field if the Flag is not set to Yes.
Any ideas?
Bill George
--
William H. George
VP, Operations
Quality Painting & Wallcoverings, Inc.
Gérard Ducouret said:Hello Karen,
You can't show Graphical indicators on a Project's standard field such as
Status.
But you can transfer the Status values in a customized field such as
Number1, with a simple formula : [Status] that you'll find in the "Number"
Field list.
Then you'll see that:
- Complete = 0
- On Schedule = 1
- Late = 2
- Future task = 3
So it's easy to define Graphical indicators for each value
Hope this helps,
Gérard Ducouret
Karen M said:I want to create a report that shows graphical characters (Yellow, Green,
Red) using the status field. Is there a way to do this? Has anyone done
this before?
Gérard Ducouret said:Hello Bill,
A flag field is a boolean field, that is to say that it can have only 2
values : Yes or No, True or False. Never an empty string like "". ;-(
By the way, you can nest several IIF functions in a formula.
Gérard Ducouret
WHGeorge said:Gerard, I am us the flag field much in the way described (in Task Usage view)
and the problem I am have is that the Flag Field is being set to "No" for all
the resources under any particular Task, which is distracting from the Flag
itself. I have tried several variations on the IIF function to try and
elminate the No response all to no avail.
I don't know if you can nest IIF statements in Project, but one of the trys
I made looks like this:
IIf([Number20]>[Number2],Yes,IIf([Number20]=0,"",""))
What I am ultimately trying to do is simply eliminate any visible content in
the Flag field if the Flag is not set to Yes.
Any ideas?
Bill George
--
William H. George
VP, Operations
Quality Painting & Wallcoverings, Inc.
Gérard Ducouret said:Hello Karen,
You can't show Graphical indicators on a Project's standard field such as
Status.
But you can transfer the Status values in a customized field such as
Number1, with a simple formula : [Status] that you'll find in the "Number"
Field list.
Then you'll see that:
- Complete = 0
- On Schedule = 1
- Late = 2
- Future task = 3
So it's easy to define Graphical indicators for each value
Hope this helps,
Gérard Ducouret
"Karen M" <[email protected]> a écrit dans le message de
I want to create a report that shows graphical characters (Yellow, Green,
Red) using the status field. Is there a way to do this? Has anyone done
this before?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.