Calculated Fields

[kknudson]

Can anyone point me to a good reference so I can learn how
to write formulas for calculated fields?

Thanks,

Ken

 

[Sean]

Ken:

Are you looking to learn VB or are you looking to
understand Project's syntax? For the latter, I would
advise you to use the Project help files as much as
possible since there really isn't anything on the market
worth buying that will teach you how to calculate custom
fields in Project.

If you're looking to learn VB, there are scores of
manuals on the market. The biggest problem is finding
one that fits your learning style.

Hope this helps!

 

[kknudson]

A little of both I guess. I'm trying to write a formula
to create a stoplight column to show project status (on
schedule, behind schedule).

 

[Sean]

Ken:

Don't waste your time with VB. You can do this in Tools,
Customize, Fields. All you need to do is learn the
calculation syntax. If you've used Excel in the past,
the syntax is essentially the same. Project is quite
kind in providing tools to make building calcs much
easier. Again, use the help files provided in Project to
ease the process. To assign a stoplight, use the
graphical indicator button on the custom field dialog box.

Good Luck!

 

[David]

I am working on the same issue. For example is it possible to add remaining duration to today's date?
Thanks.

 

[John]

David,
Yes. Assume the result is put into spare field Date1, the formula to use
is: (Note: this assumes you want to add Remaining Duation as working
days given the current Project calendar.)

Date1 = ProjDateAdd([Current Date],[Remaining Duration])

Hope this helps.
John