How do I change a field with a formula to something else?

[FiachraFiachra]

Hi,

Hopefully I'm not asking an obvious question...
I have a column of values calculated using a formula. I'd like to
modify the contents of one of the cells to a different value that has
no relation to the formula, while leaving the rest of the cells
untouched.

Any suggestions?

Thanks for your time,
Fiachra

 

[Jim Aksel]

When you look at Customize Fields the three choices (None, Value List,
Formula) are mutually exclusive. You may not override on one task as "None"
while holding the remaining to "Formula".

You could, however, alter your formula from what you have now:
=formula1
to something like this:

if(test, formula1, formula2)

This way, you can perform some type of test to determine which formula to
apply.

A more general form would be the Choose or Switch statements as the formula.

It may be possible to make a change in the Graphical Indicators area to
display indiators based on the result of the formula.
--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project