Status Indicator

[projectnewbie]

I created a custom Text1 field to obtain status on my project. My criteria is:

If Finish Variance on any task is less than 10 days return value “On Scheduleâ€
If Finish Variance on any task is greater than 11 days but less than 30
days, return value “At Risk
If Finish Variance on any task is greater than 31 days, return value “Lateâ€

I read the past group discussions to see if I can modify an existing
formula. I came up with the following formula:

IIf([Finish Variance]<10,"On Schedule", IIf([Finish Variance]>11 And [Finish
Variance]<30,"At Risk", IIf([Finish Variance]>31,"Late")))

The formula did not work as expected. Basically, the result showed that all
tasks with Finish Variance of zero or less is “On Scheduleâ€. And any task
with a Finish Variance greater than zero, is “Lateâ€.

Please advise on what I'm doing wrong. Am I using the right function? Please
help.

 

[JulieS]

Hi Projectnewbie,

I haven't had time to do more than a quick test, but I believe the
problem you are seeing is that the [Finish Variance] field calculates
the data in minutes. Try modifying the formula as I have noted below
and see if it shows what you need.

IIf([Finish Variance]<10*[Minutes Per Day],"On Schedule",IIf([Finish
Variance]>11*[Minutes Per Day] And [Finish Variance]<30*[Minutes Per
Day],"At Risk",IIf([Finish Variance]>31*[Minutes Per Day],"Late")))

Also, as a side comment, what if a task is between 10 and 11 days in
finish variance or between 30 and 31 days? You may want to tweak your
comparisons to account for that.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[projectnewbie]

JulieS,

Thank you so much. It worked! Also, I changed the criteria as you suggested
to account for tasks between 10 and 11 days, and 30 and 31 days.

Again, thank you for your quick response.

Hi Projectnewbie,

I haven't had time to do more than a quick test, but I believe the
problem you are seeing is that the [Finish Variance] field calculates
the data in minutes. Try modifying the formula as I have noted below
and see if it shows what you need.

IIf([Finish Variance]<10*[Minutes Per Day],"On Schedule",IIf([Finish
Variance]>11*[Minutes Per Day] And [Finish Variance]<30*[Minutes Per
Day],"At Risk",IIf([Finish Variance]>31*[Minutes Per Day],"Late")))

Also, as a side comment, what if a task is between 10 and 11 days in
finish variance or between 30 and 31 days? You may want to tweak your
comparisons to account for that.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

I created a custom Text1 field to obtain status on my project. My
criteria is:

If Finish Variance on any task is less than 10 days return value "On
Schedule"
If Finish Variance on any task is greater than 11 days but less than
30
days, return value "At Risk
If Finish Variance on any task is greater than 31 days, return value
"Late"

I read the past group discussions to see if I can modify an existing
formula. I came up with the following formula:

IIf([Finish Variance]<10,"On Schedule", IIf([Finish Variance]>11 And
[Finish
Variance]<30,"At Risk", IIf([Finish Variance]>31,"Late")))

The formula did not work as expected. Basically, the result showed
that all
tasks with Finish Variance of zero or less is "On Schedule". And any
task
with a Finish Variance greater than zero, is "Late".

Please advise on what I'm doing wrong. Am I using the right function?
Please
help.

 

[Jim Aksel]

Project calculates everything in minutes.
Try this:

IIf([Finish Variance]<=10*[minutes per day],"On Schedule", IIf([Finish
Variance]>10*[minutes per day] And [Finish
Variance]<=30*[minutes per day],"At Risk", IIf([Finish
Variance]>=30*[minutes per day],"Late")))

Take note that I changed the numbers to make sure there was complete
coverage. Remember, you have to do this down to the minute.
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[Jim Aksel]

Looks like Julie and I were having a typing contest... I'm glad she was able
to get the problem solved for you.

JulieS,

Thank you so much. It worked! Also, I changed the criteria as you suggested
to account for tasks between 10 and 11 days, and 30 and 31 days.

Again, thank you for your quick response.

Hi Projectnewbie,

I haven't had time to do more than a quick test, but I believe the
problem you are seeing is that the [Finish Variance] field calculates
the data in minutes. Try modifying the formula as I have noted below
and see if it shows what you need.

IIf([Finish Variance]<10*[Minutes Per Day],"On Schedule",IIf([Finish
Variance]>11*[Minutes Per Day] And [Finish Variance]<30*[Minutes Per
Day],"At Risk",IIf([Finish Variance]>31*[Minutes Per Day],"Late")))

Also, as a side comment, what if a task is between 10 and 11 days in
finish variance or between 30 and 31 days? You may want to tweak your
comparisons to account for that.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

I created a custom Text1 field to obtain status on my project. My
criteria is:

If Finish Variance on any task is less than 10 days return value "On
Schedule"
If Finish Variance on any task is greater than 11 days but less than
30
days, return value "At Risk
If Finish Variance on any task is greater than 31 days, return value
"Late"

I read the past group discussions to see if I can modify an existing
formula. I came up with the following formula:

IIf([Finish Variance]<10,"On Schedule", IIf([Finish Variance]>11 And
[Finish
Variance]<30,"At Risk", IIf([Finish Variance]>31,"Late")))

The formula did not work as expected. Basically, the result showed
that all
tasks with Finish Variance of zero or less is "On Schedule". And any
task
with a Finish Variance greater than zero, is "Late".

Please advise on what I'm doing wrong. Am I using the right function?
Please
help.

 

[Jim Aksel]

Check this carefully --- It looks like I have some >= that create a double
counting spot. Make sure your boundary value numbers use the equal sign (=)
only on one side of the test.

That's what I get for typing, talking on the phone and eating lunch all at
the same time.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

Project calculates everything in minutes.
Try this:

IIf([Finish Variance]<=10*[minutes per day],"On Schedule", IIf([Finish
Variance]>10*[minutes per day] And [Finish
Variance]<=30*[minutes per day],"At Risk", IIf([Finish
Variance]>=30*[minutes per day],"Late")))

Take note that I changed the numbers to make sure there was complete
coverage. Remember, you have to do this down to the minute.
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

I created a custom Text1 field to obtain status on my project. My criteria is:

If Finish Variance on any task is less than 10 days return value “On Scheduleâ€
If Finish Variance on any task is greater than 11 days but less than 30
days, return value “At Risk
If Finish Variance on any task is greater than 31 days, return value “Lateâ€

I read the past group discussions to see if I can modify an existing
formula. I came up with the following formula:

IIf([Finish Variance]<10,"On Schedule", IIf([Finish Variance]>11 And [Finish
Variance]<30,"At Risk", IIf([Finish Variance]>31,"Late")))

The formula did not work as expected. Basically, the result showed that all
tasks with Finish Variance of zero or less is “On Scheduleâ€. And any task
with a Finish Variance greater than zero, is “Lateâ€.

Please advise on what I'm doing wrong. Am I using the right function? Please
help.

 

[JulieS]

You're most welcome, projectnewbie, and thanks for the feedback

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

JulieS,

Thank you so much. It worked! Also, I changed the criteria as you
suggested
to account for tasks between 10 and 11 days, and 30 and 31 days.

Again, thank you for your quick response.

Hi Projectnewbie,

I haven't had time to do more than a quick test, but I believe the
problem you are seeing is that the [Finish Variance] field calculates
the data in minutes. Try modifying the formula as I have noted below
and see if it shows what you need.

IIf([Finish Variance]<10*[Minutes Per Day],"On Schedule",IIf([Finish
Variance]>11*[Minutes Per Day] And [Finish Variance]<30*[Minutes Per
Day],"At Risk",IIf([Finish Variance]>31*[Minutes Per Day],"Late")))

Also, as a side comment, what if a task is between 10 and 11 days in
finish variance or between 30 and 31 days? You may want to tweak
your
comparisons to account for that.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project

I created a custom Text1 field to obtain status on my project. My
criteria is:

If Finish Variance on any task is less than 10 days return value
"On
Schedule"
If Finish Variance on any task is greater than 11 days but less
than
30
days, return value "At Risk
If Finish Variance on any task is greater than 31 days, return
value
"Late"

I read the past group discussions to see if I can modify an
existing
formula. I came up with the following formula:

IIf([Finish Variance]<10,"On Schedule", IIf([Finish Variance]>11
And
[Finish
Variance]<30,"At Risk", IIf([Finish Variance]>31,"Late")))

The formula did not work as expected. Basically, the result showed
that all
tasks with Finish Variance of zero or less is "On Schedule". And
any
task
with a Finish Variance greater than zero, is "Late".

Please advise on what I'm doing wrong. Am I using the right
function?
Please
help.

 

[JulieS]

Looks like Julie and I were having a typing contest... I'm glad she
was able
to get the problem solved for you.

<snip>

Hi Jim,

Luckily we both came up with the same answer too ;-)

Julie

 

[Jim Aksel]

Shocking, isn't it?

<snip>

Hi Jim,

Luckily we both came up with the same answer too ;-)

Julie