What Formula Language

R

Ray

Hello,
I've got a real simple question, I feel really dumb not knowing this, but
I've never used a Formula before for a Custom Field. What language, if any,
is this in? I'd like to look it up in a book, but I don't know what to look
in. Any clues for the clueless would be greatly appreciated.
Cheers, Ray
 
R

Rod Gill

Hi,

There isn't a 'language' for formulas, they are just formulas much the same
way as formulas in Excel. The Customize Fields dialog provides a list of all
available functions for formulas. You can also refer to fields for the
current task.
 
J

John

Ray said:
Hello,
I've got a real simple question, I feel really dumb not knowing this, but
I've never used a Formula before for a Custom Field. What language, if any,
is this in? I'd like to look it up in a book, but I don't know what to look
in. Any clues for the clueless would be greatly appreciated.
Cheers, Ray

Ray,
I don't know if there is a specific language definition for the formulas
in Project but they very closely follow the syntax of Visual Basic.
There is a set of definitions for formulas in Project but in my opinion
not only is the information difficult to find but there is very little
explanation about arguments once you do find it. What I usually do is to
look up the similar function, method, etc. using the VBA help file in
Project.

Just for reference, in Project 2003, the help file for formulas can be
found under "Project functions" (yeah, as if that's the keyword that
pops into mind when looking for information about formulas). For a
better definition, go to Tools/Macro/Visual Basic Editor. Hit the object
browser icon and then set MSProject as the object library in the upper
left selection box. Form there type in the function, method, etc. as the
search text and select the most appropriate item from the search
results. Hitting the question mark icon will bring up the syntax
information about that particular item.

Hope this helps.
John
Project MVP
 

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

Top