Project 2002, New User Question

[Paul Axelrod]

I just upgraded from Project 98 to 2002, and am beginning to work with
adding custom fields to various tables with calculations being done in
the new fields.
I have some fields wherein I would like to have the formula apply to
only one or two tasks in my task list, a list of 345 tasks altogether.
I can not figure out a way to accomplish this. Is it possible to get
a formula into just one cell in the table. I was able to get the
display to show this by changing font color to white in those fields I
dont want the calculated value to appear, but it is there and shows up
in the editing bar.
Any suggestions would be appreciated. If it cant be done I would also
appreciate being told so, so I wont waste more time on this.
Thank you very much for any help.

 

[Jack D.]

I just upgraded from Project 98 to 2002, and am beginning to work with
adding custom fields to various tables with calculations being done in
the new fields.
I have some fields wherein I would like to have the formula apply to
only one or two tasks in my task list, a list of 345 tasks altogether.
I can not figure out a way to accomplish this. Is it possible to get
a formula into just one cell in the table. I was able to get the
display to show this by changing font color to white in those fields I
dont want the calculated value to appear, but it is there and shows up
in the editing bar.
Any suggestions would be appreciated. If it cant be done I would also
appreciate being told so, so I wont waste more time on this.
Thank you very much for any help.

There is a way to do this, however you will have to use another field to
indicate which tasks you want the formula to apply to.

Here is an example.

Suppose your formula is [Finish]-[Start] and you are using Text5 to hold the
formula.
Pick an unused flag field - for this example use Flag1 - and mark it "Yes"
for each task that you want to show.
Then add a conditional statement to your formula for Text5 like this:

iif([Flag1],[Finish]-[Start],"")

You can put whatever formula you like between the commas.
The iif statement has this syntax

iif(test, value if true, value if false)

You can find out more on my website on the custom fields FAQ page.


--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP


+++++++++++++++++++