RAG status - graphical indicator

[amara sharif]

I have spent hours hunting down a solution please help!!!

I want RAG indicators to highlight if a task is behind schedule / on schedule etc...

The issue that I am having : I want to compare the finish date to the CURRENT DATE? is this possible? surely there must be a default field that stores the current live date?

i.e. i want to say: If the task finish date is less than the current date & is less than 100% complete, flag as RED?

 

[Jonathan Sofer [MVP]]

When defining your formula, under "Field>Project>Date>..." there are many
date fields available to you including [Current Date]. The formual below
was created on Text1 field and I made the graphical indicator "contains Red
then red circler" or contains Green then green circle", I also enabled the
"Show data values in ToolTip" check box so when you hove over you can see
the text.

IIf([Finish]<[Current Date] And [% Complete]<100,"Red, Overdue","Green, Not
Overdue")

Set
in message news:[email protected]...

 

[Amara]

Thanks for that. It worked!

How would you do this:

If a task is more than 20% late than its estimated duration, then flag it
red????

When defining your formula, under "Field>Project>Date>..." there are many
date fields available to you including [Current Date]. The formual below
was created on Text1 field and I made the graphical indicator "contains Red
then red circler" or contains Green then green circle", I also enabled the
"Show data values in ToolTip" check box so when you hove over you can see
the text.

IIf([Finish]<[Current Date] And [% Complete]<100,"Red, Overdue","Green, Not
Overdue")

Set

I have spent hours hunting down a solution please help!!!

I want RAG indicators to highlight if a task is behind schedule / on
schedule etc...

The issue that I am having : I want to compare the finish date to the
CURRENT DATE? is this possible? surely there must be a default field that
stores the current live date?

i.e. i want to say: If the task finish date is less than the current date
& is less than 100% complete, flag as RED?

 

[Jonathan Sofer [MVP]]

You would need to have a baseline to determine the estimated duration. If
you have a baseline you could use this formula like this:

IIf([Baseline Start]>55000,"No Baseline",IIf([Finish
Variance]/[Duration]>=0.20,"Red",IIf([Finish
Variance]/[Duration]>=0.10,"Yellow","Green")))

Jonathan

Thanks for that. It worked!

How would you do this:

If a task is more than 20% late than its estimated duration, then flag it
red????

When defining your formula, under "Field>Project>Date>..." there are many
date fields available to you including [Current Date]. The formual below
was created on Text1 field and I made the graphical indicator "contains
Red
then red circler" or contains Green then green circle", I also enabled
the
"Show data values in ToolTip" check box so when you hove over you can see
the text.

IIf([Finish]<[Current Date] And [% Complete]<100,"Red, Overdue","Green,
Not
Overdue")

Set

I have spent hours hunting down a solution please help!!!

I want RAG indicators to highlight if a task is behind schedule / on
schedule etc...

The issue that I am having : I want to compare the finish date to the
CURRENT DATE? is this possible? surely there must be a default field
that
stores the current live date?

i.e. i want to say: If the task finish date is less than the current
date
& is less than 100% complete, flag as RED?