is their any syntax training on MS Project formulas?

[Bud]

I am looking for syntax information or training on MS Project formulas for
using on custom fields. I know of the iif statement, etc. but there doesn't
seem to be any documentation on the syntax constructs for formulas.

Is this located on Microsoft somewhere or in a recommended book?

Thanks

 

[Mike Glen]

Hi Bud,

Welcome to this Microsoft Project newsgroup

Try searching Help for functions and select Project Functions.

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

 

[John]

I am looking for syntax information or training on MS Project formulas for
using on custom fields. I know of the iif statement, etc. but there doesn't
seem to be any documentation on the syntax constructs for formulas.

Is this located on Microsoft somewhere or in a recommended book?

Thanks

Bud,
Just a follow-on to Mike's comment. I find the syntax descriptions for
Project functions leave a lot to be desired - there is no explanation
about the arguments. However since most Project functions are very
similar to methods used in VBA, you might want to take a look at the
syntax descriptions for VBA methods. To view VBA method syntax (which
does give argument descriptions), go to Tools/Macros/Visual Basic
Editor. When the VB editor window opens, go to View/Object Browser. The
Object Browser will offer help with all object libraries that are
referenced, not just Project objects. For the most part you can enter
the function into the search window and you will get a list of possible
classes and members. Select and click on the desired member and you will
get the full syntax for that object property or method.

Hope this helps.
John
Project MVP