Status Column not PC Enough

G

gja

While reviewing a project with my group I received the following comment. For
status (complete, late, future) the late seemed harsh, they thought we should
change it to "in progress". I feel that being late is realty, but if I am
asked to change this label for public presentations is there a way to do this?

George
 
A

Andrew

Easy enough....just create a custom text field with the following formula
(make your own adaptions)

IIf([Status]=0,"Complete",IIf([Status]=1,"On
Time",IIf([Status]=2,"Lateish","Future")))
 
G

gja

Hello Andrew,

Thanks for your response. However, I am having trouble getting this to work.
I tried the following:
In the Gnatt View I inserted a column next to the status column, named, then
highlighted it
Chose customize fields under the tools menu
Inserted the formula for Text 1
Custom attributes, chose Formula
Calculation for task and group summary rows, Chose Use formula
Values to display, Chose Data

The inserted column stays like when it was inserted, numbered 1,2,3,4.....

Any suggestions? I just want the status column or inserted column to indicate
Complete
On Schedule
In Progress
Future Task

instead of

Complete
On Schedule
Late
Future Task

Thank you for any additional comments or suggestions.
George

Andrew said:
Easy enough....just create a custom text field with the following formula
(make your own adaptions)

IIf([Status]=0,"Complete",IIf([Status]=1,"On
Time",IIf([Status]=2,"Lateish","Future")))



gja said:
While reviewing a project with my group I received the following comment. For
status (complete, late, future) the late seemed harsh, they thought we should
change it to "in progress". I feel that being late is realty, but if I am
asked to change this label for public presentations is there a way to do this?

George
Click to expand...
Click to expand...
 
J

JulieS

Hello George,

Pardon me for bumping in. I just tested Andrew's formula and it works
just fine. When you note you "inserted the formula for Text 1" did
you use the formula Andrew listed ? Do you insert the Text1 field?
I've repeated the formula that Andrew gave you with the change that
tasks that have a "Late" status appear as "In Progress" as you asked.

IIf([Status]=0,"Complete",IIf([Status]=1,"On Time",IIf([Status]=2,"In
Progress","Future")))

Try copying and pasting the formula into the formula box that appears
when you click the formula button.

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



gja said:
Hello Andrew,

Thanks for your response. However, I am having trouble getting this
to work.
I tried the following:
In the Gnatt View I inserted a column next to the status column,
named, then
highlighted it
Chose customize fields under the tools menu
Inserted the formula for Text 1
Custom attributes, chose Formula
Calculation for task and group summary rows, Chose Use formula
Values to display, Chose Data

The inserted column stays like when it was inserted, numbered
1,2,3,4.....

Any suggestions? I just want the status column or inserted column to
indicate
Complete
On Schedule
In Progress
Future Task

instead of

Complete
On Schedule
Late
Future Task

Thank you for any additional comments or suggestions.
George

Andrew said:
Easy enough....just create a custom text field with the following
formula
(make your own adaptions)

IIf([Status]=0,"Complete",IIf([Status]=1,"On
Time",IIf([Status]=2,"Lateish","Future")))



gja said:
While reviewing a project with my group I received the following
comment. For
status (complete, late, future) the late seemed harsh, they
thought we should
change it to "in progress". I feel that being late is realty, but
if I am
asked to change this label for public presentations is there a
way to do this?

George
Click to expand...
Click to expand...
Click to expand...
 
G

gja

Hello Julie,

Thank you for the help. The formula I ended up using was:

IIf([Status]=0,"Complete",IIf([Status]=1,"On Schedule",IIf([Status]=2,"In
Progress",IIf([Status]=3,"Future Task"))))

Have a good weekend.

JulieS said:
Hello George,

Pardon me for bumping in. I just tested Andrew's formula and it works
just fine. When you note you "inserted the formula for Text 1" did
you use the formula Andrew listed ? Do you insert the Text1 field?
I've repeated the formula that Andrew gave you with the change that
tasks that have a "Late" status appear as "In Progress" as you asked.

IIf([Status]=0,"Complete",IIf([Status]=1,"On Time",IIf([Status]=2,"In
Progress","Future")))

Try copying and pasting the formula into the formula box that appears
when you click the formula button.

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



gja said:
Hello Andrew,

Thanks for your response. However, I am having trouble getting this
to work.
I tried the following:
In the Gnatt View I inserted a column next to the status column,
named, then
highlighted it
Chose customize fields under the tools menu
Inserted the formula for Text 1
Custom attributes, chose Formula
Calculation for task and group summary rows, Chose Use formula
Values to display, Chose Data

The inserted column stays like when it was inserted, numbered
1,2,3,4.....

Any suggestions? I just want the status column or inserted column to
indicate
Complete
On Schedule
In Progress
Future Task

instead of

Complete
On Schedule
Late
Future Task

Thank you for any additional comments or suggestions.
George

Andrew said:
Easy enough....just create a custom text field with the following
formula
(make your own adaptions)

IIf([Status]=0,"Complete",IIf([Status]=1,"On
Time",IIf([Status]=2,"Lateish","Future")))



:

While reviewing a project with my group I received the following
comment. For
status (complete, late, future) the late seemed harsh, they
thought we should
change it to "in progress". I feel that being late is realty, but
if I am
asked to change this label for public presentations is there a
way to do this?

George
Click to expand...
Click to expand...
Click to expand...
 
J

JulieS

Hello gja,

I'm glad you got things working. There is an error in the formula that
you've copied below (it doesn't include a final argument), but I'm going
to assume that was just a copy/paste error from Project into the
message.

Glad to hear you have formula which works for your needs.

Julie

gja said:
Hello Julie,

Thank you for the help. The formula I ended up using was:

IIf([Status]=0,"Complete",IIf([Status]=1,"On
Schedule",IIf([Status]=2,"In
Progress",IIf([Status]=3,"Future Task"))))

Have a good weekend.

JulieS said:
Hello George,

Pardon me for bumping in. I just tested Andrew's formula and it
works
just fine. When you note you "inserted the formula for Text 1" did
you use the formula Andrew listed ? Do you insert the Text1 field?
I've repeated the formula that Andrew gave you with the change that
tasks that have a "Late" status appear as "In Progress" as you asked.

IIf([Status]=0,"Complete",IIf([Status]=1,"On Time",IIf([Status]=2,"In
Progress","Future")))

Try copying and pasting the formula into the formula box that appears
when you click the formula button.

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



gja said:
Hello Andrew,

Thanks for your response. However, I am having trouble getting this
to work.
I tried the following:
In the Gnatt View I inserted a column next to the status column,
named, then
highlighted it
Chose customize fields under the tools menu
Inserted the formula for Text 1
Custom attributes, chose Formula
Calculation for task and group summary rows, Chose Use formula
Values to display, Chose Data

The inserted column stays like when it was inserted, numbered
1,2,3,4.....

Any suggestions? I just want the status column or inserted column
to
indicate
Complete
On Schedule
In Progress
Future Task

instead of

Complete
On Schedule
Late
Future Task

Thank you for any additional comments or suggestions.
George

:

Easy enough....just create a custom text field with the following
formula
(make your own adaptions)

IIf([Status]=0,"Complete",IIf([Status]=1,"On
Time",IIf([Status]=2,"Lateish","Future")))



:

While reviewing a project with my group I received the following
comment. For
status (complete, late, future) the late seemed harsh, they
thought we should
change it to "in progress". I feel that being late is realty,
but
if I am
asked to change this label for public presentations is there a
way to do this?

George
Click to expand...
Click to expand...
Click to expand...
 
G

gja

Hello Julie,

What do you mean by a final agrument? I am just curious, because I double
checked the formula below and that is the one I used and it seems to work.
Did I just get lucky?

George

JulieS said:
Hello gja,

I'm glad you got things working. There is an error in the formula that
you've copied below (it doesn't include a final argument), but I'm going
to assume that was just a copy/paste error from Project into the
message.

Glad to hear you have formula which works for your needs.

Julie

gja said:
Hello Julie,

Thank you for the help. The formula I ended up using was:

IIf([Status]=0,"Complete",IIf([Status]=1,"On
Schedule",IIf([Status]=2,"In
Progress",IIf([Status]=3,"Future Task"))))

Have a good weekend.

JulieS said:
Hello George,

Pardon me for bumping in. I just tested Andrew's formula and it
works
just fine. When you note you "inserted the formula for Text 1" did
you use the formula Andrew listed ? Do you insert the Text1 field?
I've repeated the formula that Andrew gave you with the change that
tasks that have a "Late" status appear as "In Progress" as you asked.

IIf([Status]=0,"Complete",IIf([Status]=1,"On Time",IIf([Status]=2,"In
Progress","Future")))

Try copying and pasting the formula into the formula box that appears
when you click the formula button.

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



Hello Andrew,

Thanks for your response. However, I am having trouble getting this
to work.
I tried the following:
In the Gnatt View I inserted a column next to the status column,
named, then
highlighted it
Chose customize fields under the tools menu
Inserted the formula for Text 1
Custom attributes, chose Formula
Calculation for task and group summary rows, Chose Use formula
Values to display, Chose Data

The inserted column stays like when it was inserted, numbered
1,2,3,4.....

Any suggestions? I just want the status column or inserted column
to
indicate
Complete
On Schedule
In Progress
Future Task

instead of

Complete
On Schedule
Late
Future Task

Thank you for any additional comments or suggestions.
George

:

Easy enough....just create a custom text field with the following
formula
(make your own adaptions)

IIf([Status]=0,"Complete",IIf([Status]=1,"On
Time",IIf([Status]=2,"Lateish","Future")))



:

While reviewing a project with my group I received the following
comment. For
status (complete, late, future) the late seemed harsh, they
thought we should
change it to "in progress". I feel that being late is realty,
but
if I am
asked to change this label for public presentations is there a
way to do this?

George
Click to expand...
Click to expand...
Click to expand...
 
J

JulieS

Hello George,

Sorry for the cryptic nature of my post :) The IIF formula has the
following syntax:

IIF( expression, truepart, falsepart).

You have nested several IIf functions together which is just fine, but
you are missing one of the pieces of the formula. I tested your formula
substituting [Text2] for the [Status] field and it throws an error if
[Text2] equals 2.

If you compare Andrew's original formula with yours, you'll see he
omitted the IIf([Status]=3 expression from his formula which you
included in yours. Does your formula work for all of the possibilities?

If we compare the two formulas, I think you'll see the error. I've
mapped the <<Expression>>, <<Truepart>>, and <<FalsePart>> syntax into
both your formula and Andrew's.

First Andrew's:
IIf([Status]=0<<Expression1>>,
"Complete"<<TruePart1>>,
IIf([Status]=1<<FalsePart1>><<Expression2>>,
"On Time"<<TruePart2>>,
IIf([Status]=2<<FalsePart2>><<Expression3>>,
"Lateish"<<TruePart3>>,
"Future"<<FalsePart3>>)))

Now your formula:

IIf([Status]=0,<<Expression1>>
"Complete"<<Truepart1>>,
IIf([Status]=1<<FalsePart1>><<Expression2>>,
"On Schedule"<<Truepart2>>,
IIf([Status]=2<<FalsePart2>><<Expression3>>,
"In Progress"<<TruePart3>>
,IIf([Status]=3<<FalsePart3, <<Expression4>>,
"Future Task"<<TruePart4>>))))

You have no "falsepart" for your last expression. IIFs cannot have an
even number of arguments. Andrew's formula has 7 parts, yours has 8.

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

gja said:
Hello Julie,

What do you mean by a final agrument? I am just curious, because I
double
checked the formula below and that is the one I used and it seems to
work.
Did I just get lucky?

George

JulieS said:
Hello gja,

I'm glad you got things working. There is an error in the formula
that
you've copied below (it doesn't include a final argument), but I'm
going
to assume that was just a copy/paste error from Project into the
message.

Glad to hear you have formula which works for your needs.

Julie

gja said:
Hello Julie,

Thank you for the help. The formula I ended up using was:

IIf([Status]=0,"Complete",IIf([Status]=1,"On
Schedule",IIf([Status]=2,"In
Progress",IIf([Status]=3,"Future Task"))))

Have a good weekend.

:

Hello George,

Pardon me for bumping in. I just tested Andrew's formula and it
works
just fine. When you note you "inserted the formula for Text 1"
did
you use the formula Andrew listed ? Do you insert the Text1
field?
I've repeated the formula that Andrew gave you with the change
that
tasks that have a "Late" status appear as "In Progress" as you
asked.

IIf([Status]=0,"Complete",IIf([Status]=1,"On
Time",IIf([Status]=2,"In
Progress","Future")))

Try copying and pasting the formula into the formula box that
appears
when you click the formula button.

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



Hello Andrew,

Thanks for your response. However, I am having trouble getting
this
to work.
I tried the following:
In the Gnatt View I inserted a column next to the status column,
named, then
highlighted it
Chose customize fields under the tools menu
Inserted the formula for Text 1
Custom attributes, chose Formula
Calculation for task and group summary rows, Chose Use formula
Values to display, Chose Data

The inserted column stays like when it was inserted, numbered
1,2,3,4.....

Any suggestions? I just want the status column or inserted
column
to
indicate
Complete
On Schedule
In Progress
Future Task

instead of

Complete
On Schedule
Late
Future Task

Thank you for any additional comments or suggestions.
George

:

Easy enough....just create a custom text field with the
following
formula
(make your own adaptions)

IIf([Status]=0,"Complete",IIf([Status]=1,"On
Time",IIf([Status]=2,"Lateish","Future")))



:

While reviewing a project with my group I received the
following
comment. For
status (complete, late, future) the late seemed harsh, they
thought we should
change it to "in progress". I feel that being late is realty,
but
if I am
asked to change this label for public presentations is there
a
way to do this?

George
Click to expand...
Click to expand...
Click to expand...
 
G

gja

Thanks JulieS - the formula works and is now also in the right format.


JulieS said:
Hello George,

Sorry for the cryptic nature of my post :) The IIF formula has the
following syntax:

IIF( expression, truepart, falsepart).

You have nested several IIf functions together which is just fine, but
you are missing one of the pieces of the formula. I tested your formula
substituting [Text2] for the [Status] field and it throws an error if
[Text2] equals 2.

If you compare Andrew's original formula with yours, you'll see he
omitted the IIf([Status]=3 expression from his formula which you
included in yours. Does your formula work for all of the possibilities?

If we compare the two formulas, I think you'll see the error. I've
mapped the <<Expression>>, <<Truepart>>, and <<FalsePart>> syntax into
both your formula and Andrew's.

First Andrew's:
IIf([Status]=0<<Expression1>>,
"Complete"<<TruePart1>>,
IIf([Status]=1<<FalsePart1>><<Expression2>>,
"On Time"<<TruePart2>>,
IIf([Status]=2<<FalsePart2>><<Expression3>>,
"Lateish"<<TruePart3>>,
"Future"<<FalsePart3>>)))

Now your formula:

IIf([Status]=0,<<Expression1>>
"Complete"<<Truepart1>>,
IIf([Status]=1<<FalsePart1>><<Expression2>>,
"On Schedule"<<Truepart2>>,
IIf([Status]=2<<FalsePart2>><<Expression3>>,
"In Progress"<<TruePart3>>
,IIf([Status]=3<<FalsePart3, <<Expression4>>,
"Future Task"<<TruePart4>>))))

You have no "falsepart" for your last expression. IIFs cannot have an
even number of arguments. Andrew's formula has 7 parts, yours has 8.

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

gja said:
Hello Julie,

What do you mean by a final agrument? I am just curious, because I
double
checked the formula below and that is the one I used and it seems to
work.
Did I just get lucky?

George

JulieS said:
Hello gja,

I'm glad you got things working. There is an error in the formula
that
you've copied below (it doesn't include a final argument), but I'm
going
to assume that was just a copy/paste error from Project into the
message.

Glad to hear you have formula which works for your needs.

Julie

Hello Julie,

Thank you for the help. The formula I ended up using was:

IIf([Status]=0,"Complete",IIf([Status]=1,"On
Schedule",IIf([Status]=2,"In
Progress",IIf([Status]=3,"Future Task"))))

Have a good weekend.

:

Hello George,

Pardon me for bumping in. I just tested Andrew's formula and it
works
just fine. When you note you "inserted the formula for Text 1"
did
you use the formula Andrew listed ? Do you insert the Text1
field?
I've repeated the formula that Andrew gave you with the change
that
tasks that have a "Late" status appear as "In Progress" as you
asked.

IIf([Status]=0,"Complete",IIf([Status]=1,"On
Time",IIf([Status]=2,"In
Progress","Future")))

Try copying and pasting the formula into the formula box that
appears
when you click the formula button.

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



Hello Andrew,

Thanks for your response. However, I am having trouble getting
this
to work.
I tried the following:
In the Gnatt View I inserted a column next to the status column,
named, then
highlighted it
Chose customize fields under the tools menu
Inserted the formula for Text 1
Custom attributes, chose Formula
Calculation for task and group summary rows, Chose Use formula
Values to display, Chose Data

The inserted column stays like when it was inserted, numbered
1,2,3,4.....

Any suggestions? I just want the status column or inserted
column
to
indicate
Complete
On Schedule
In Progress
Future Task

instead of

Complete
On Schedule
Late
Future Task

Thank you for any additional comments or suggestions.
George

:

Easy enough....just create a custom text field with the
following
formula
(make your own adaptions)

IIf([Status]=0,"Complete",IIf([Status]=1,"On
Time",IIf([Status]=2,"Lateish","Future")))



:

While reviewing a project with my group I received the
following
comment. For
status (complete, late, future) the late seemed harsh, they
thought we should
change it to "in progress". I feel that being late is realty,
but
if I am
asked to change this label for public presentations is there
a
way to do this?

George
Click to expand...
Click to expand...
Click to expand...
 
J

JulieS

gja said:
Thanks JulieS - the formula works and is now also in the right format.
Click to expand...
<snip>

You're welcome George. The important thing is the formula works
consistently for all of the statuses

Julie
 

Ask a Question

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.

Ask a Question

Similar Threads

Tracking Status for beginners 11
Future assignments planned ahead 4
Unknown Error when changing Status to Complete 3
traffic light in excel 4
Table/Relationship Indetermined 1
Create Status Chart for projects 4
What about modeling real life dependencies? 0
Weird Problems with Simple Schedule Implementation 1

Top