schedule indicator

[ProjectUser]

I’ve been trying to write a formula that provides the stoplight indicator
based on a dateDiff value. I’m trying to graphically show which tasks are
late. So far my formula in a number’s customized field,
ProjDateDiff([Baseline Start],[Actual Start])/450, gives me only half of
what I need (tasks that have started, but are late); I need to also include
late tasks that haven’t started yet. I’m not sure how to incorporate this
parameter into my formula.

Please help.

 

[Jonathan Sofer]

There are pobably other conditions you will have to look for but for the one
you just specified you can replace your original formual with this instead:

ProjDateDiff([Baseline Start],[Start])/480

The reason I changed your line to use [Start] instead of [Actual Start] is
because [Start] will always exist as apposed to [Actual Start] which only
exists once the task has started. Also [Start] will always equal [Actual
Start] once the task has begun.

FYI, if you want a conditional statement that shows you whether [Actual
Start] is NA then you can use this: IIF([Actual Starts] > 55000, true,
false)

I also changed 450 to 480 which is 60 minutes * 8 hrs/day. But if you have
changed your working days to 7.5 hrs/day then your 450 should be correct.

Jonathan Sofer

 

[ProjectUser]

Thanks Jonathan!

There are pobably other conditions you will have to look for but for the one
you just specified you can replace your original formual with this instead:

ProjDateDiff([Baseline Start],[Start])/480

The reason I changed your line to use [Start] instead of [Actual Start] is
because [Start] will always exist as apposed to [Actual Start] which only
exists once the task has started. Also [Start] will always equal [Actual
Start] once the task has begun.

FYI, if you want a conditional statement that shows you whether [Actual
Start] is NA then you can use this: IIF([Actual Starts] > 55000, true,
false)

I also changed 450 to 480 which is 60 minutes * 8 hrs/day. But if you have
changed your working days to 7.5 hrs/day then your 450 should be correct.

Jonathan Sofer

I've been trying to write a formula that provides the stoplight indicator
based on a dateDiff value. I'm trying to graphically show which tasks are
late. So far my formula in a number's customized field,
ProjDateDiff([Baseline Start],[Actual Start])/450, gives me only half of
what I need (tasks that have started, but are late); I need to also
include
late tasks that haven't started yet. I'm not sure how to incorporate this
parameter into my formula.

Please help.

 

[ProjectUser]

I had to tweak my status indicator formula and am not sure what’s missing.
Here it is: IIf([Start Variance]=0,"onSched",IIf([Start
Variance]>0,"Late",IIf([Start Variance]<0 And [Start Variance]>-5,"atRisk")))
I get an error on the fields that are below 0 in the start variance column.

please help, again

Thanks Jonathan!

There are pobably other conditions you will have to look for but for the one
you just specified you can replace your original formual with this instead:

ProjDateDiff([Baseline Start],[Start])/480

The reason I changed your line to use [Start] instead of [Actual Start] is
because [Start] will always exist as apposed to [Actual Start] which only
exists once the task has started. Also [Start] will always equal [Actual
Start] once the task has begun.

FYI, if you want a conditional statement that shows you whether [Actual
Start] is NA then you can use this: IIF([Actual Starts] > 55000, true,
false)

I also changed 450 to 480 which is 60 minutes * 8 hrs/day. But if you have
changed your working days to 7.5 hrs/day then your 450 should be correct.

Jonathan Sofer

I've been trying to write a formula that provides the stoplight indicator
based on a dateDiff value. I'm trying to graphically show which tasks are
late. So far my formula in a number's customized field,
ProjDateDiff([Baseline Start],[Actual Start])/450, gives me only half of
what I need (tasks that have started, but are late); I need to also
include
late tasks that haven't started yet. I'm not sure how to incorporate this
parameter into my formula.

Please help.

 

[Jonathan Sofer]

Two things I see:

1) -5 should be -2400 because [Start Variance] like most other duration
fields are stored in working minutes
(-5 * 480 = -2400)
2) The reason you got an error is party because of item 1 and also because
you don't have a false condition value at the end of your formula. You need
to add one to handle the fact that the [Start Variance] can be more than
2400 minutes early.

Here is an example of a working formula:

IIf([Start Variance]=0,"onSched",IIf([Start Variance]>0,"Late",IIf([Start
Variance]<0 And [Start
Variance]>-2400,"atRisk","ExampleTextForFalseCondition")))

By the way, why would a task that starts early be at risk?

Hope this helps,

Jonathan Sofer


Put in a false condition after "at Risk"

I had to tweak my status indicator formula and am not sure what's missing.
Here it is: IIf([Start Variance]=0,"onSched",IIf([Start
Variance]>0,"Late",IIf([Start Variance]<0 And [Start
Variance]>-5,"atRisk")))
I get an error on the fields that are below 0 in the start variance
column.

please help, again

Thanks Jonathan!

There are pobably other conditions you will have to look for but for
the one
you just specified you can replace your original formual with this
instead:

ProjDateDiff([Baseline Start],[Start])/480

The reason I changed your line to use [Start] instead of [Actual Start]
is
because [Start] will always exist as apposed to [Actual Start] which
only
exists once the task has started. Also [Start] will always equal
[Actual
Start] once the task has begun.

FYI, if you want a conditional statement that shows you whether [Actual
Start] is NA then you can use this: IIF([Actual Starts] > 55000, true,
false)

I also changed 450 to 480 which is 60 minutes * 8 hrs/day. But if you
have
changed your working days to 7.5 hrs/day then your 450 should be
correct.

Jonathan Sofer


I've been trying to write a formula that provides the stoplight
indicator
based on a dateDiff value. I'm trying to graphically show which
tasks are
late. So far my formula in a number's customized field,
ProjDateDiff([Baseline Start],[Actual Start])/450, gives me only
half of
what I need (tasks that have started, but are late); I need to also
include
late tasks that haven't started yet. I'm not sure how to incorporate
this
parameter into my formula.

Please help.

 

[ProjectUser]

Thanks again Jonathan,

That solved my problem! Why "atRisk"? just doing what I'm told )

Two things I see:

1) -5 should be -2400 because [Start Variance] like most other duration
fields are stored in working minutes
(-5 * 480 = -2400)
2) The reason you got an error is party because of item 1 and also because
you don't have a false condition value at the end of your formula. You need
to add one to handle the fact that the [Start Variance] can be more than
2400 minutes early.

Here is an example of a working formula:

IIf([Start Variance]=0,"onSched",IIf([Start Variance]>0,"Late",IIf([Start
Variance]<0 And [Start
Variance]>-2400,"atRisk","ExampleTextForFalseCondition")))

By the way, why would a task that starts early be at risk?

Hope this helps,

Jonathan Sofer


Put in a false condition after "at Risk"

I had to tweak my status indicator formula and am not sure what's missing.
Here it is: IIf([Start Variance]=0,"onSched",IIf([Start
Variance]>0,"Late",IIf([Start Variance]<0 And [Start
Variance]>-5,"atRisk")))
I get an error on the fields that are below 0 in the start variance
column.

please help, again

Thanks Jonathan!

:

There are pobably other conditions you will have to look for but for
the one
you just specified you can replace your original formual with this
instead:

ProjDateDiff([Baseline Start],[Start])/480

The reason I changed your line to use [Start] instead of [Actual Start]
is
because [Start] will always exist as apposed to [Actual Start] which
only
exists once the task has started. Also [Start] will always equal
[Actual
Start] once the task has begun.

FYI, if you want a conditional statement that shows you whether [Actual
Start] is NA then you can use this: IIF([Actual Starts] > 55000, true,
false)

I also changed 450 to 480 which is 60 minutes * 8 hrs/day. But if you
have
changed your working days to 7.5 hrs/day then your 450 should be
correct.

Jonathan Sofer


I've been trying to write a formula that provides the stoplight
indicator
based on a dateDiff value. I'm trying to graphically show which
tasks are
late. So far my formula in a number's customized field,
ProjDateDiff([Baseline Start],[Actual Start])/450, gives me only
half of
what I need (tasks that have started, but are late); I need to also
include
late tasks that haven't started yet. I'm not sure how to incorporate
this
parameter into my formula.

Please help.