Using formulas in MS Project

[zak]

Hi

I just wanted to know whether it would be possible to use vlookup or any
type of formulas to validate information in cells in MS Project?

If, anyone could let me know, I would really apppreciate it.

Thanks

 

[Rob Schneider]

Hi

I just wanted to know whether it would be possible to use vlookup or any
type of formulas to validate information in cells in MS Project?

If, anyone could let me know, I would really apppreciate it.

Thanks

Zak,

Project does not implement Excel's functions (vlookup). But it can do
what you want. Look at Menu: Tools/Customise/Fields and see if "Value
List" is what you are seeking. Press the help button (bottom left corner
of the Customise Fields dialog box) to get a full explanation.

If you need something more sophisticated to validate a list, e.g.
formulae that compute complicated things, I suppose you could write that
in VB.

 

[zak]

Hi Rob

I have gone into tools/customise/fields, but have not been able to find the
'if value list' option anywhere. Is it within the lookup or formula area?

Also, i don't know if i would need to make it more sophisticated. All i
need to do is validate 3 columns.

Column 1 - this column should be analysed to see if there are any cells that
do not match the list in the text 7 column.

Column 2 & 3 - this column should be validated to check that only numbers
have been entered (and not letters or any other punctuation characters) and
that the number of digits does not exceed 5.

Can you tell me if the above is possible?

Thanks

 

[Rob Schneider]

Zak,

It is the "Value List" button on the Fields Customize dialogue box.

The Value list won't do what you describe. Your needs are too
sophisticated for that. You could surely write some VB code for which
you could ask the user to hit a button to validate the data, and the VB
code would run the checks you prescribe. I suppose you could also make
your own form and the data in the form is checked before the data is
saved into the "record".

I wonder, though, if you are expecting too much of Project. It is not an
environemnt for making this sort of user inteface.