Calculating Work field using Iif statement

[will.teichman]

I have a large project file with several thousand tasks. Each task has
an assigned number work hours which it will take to complete. This
work field is the source data for my Task Usage view.

I would like to adjust the automatically adjust the amount of work
hours for each task on the basis of some letter codes in another
column. If the column value = "S", then the Work column should = hours
* .25, etc.

I figured out how to write the Iif statement for a custom field, but am
thinking that perhaps the Work field that I have set up cannot be
determined by a formula, since it's a standard field that is hard wired
into Project.

Has anyone had a similar experience, or knows a solution?

 

[Dale Howard [MVP]]

Will --

You cannot do this with a formula. Instead, you would need to write a macro
in VBA to perform the necessary calculations. Hope this helps.

 

[will.teichman]

Dale-

Thanks for the confirmation. Glad to know that it's possible, even if
by VBA.

-Will