Calculated Field Overide?

[Steve Scott]

I want to have a text field with a formula in it for certain situations only.
When those situations don't arise, can I make the field editable to allow
manual input of data?

 

[JackD]

Use two fields.
Example Text1, Text2
Use Text1 for manual entry
Put a formula in text2 which uses Text1 if it is not blank, otherwise use
the formula you wanted.

iif([Text1]<>"", [Text1], (whatever your formula is here))

 

[John]

I want to have a text field with a formula in it for certain situations only.
When those situations don't arise, can I make the field editable to allow
manual input of data?

Steve,
Well, you can't get there by using a custom field with a formula, but
you can do it with VBA. If you give us more details about the formula
and those "certain situations", we can probably help you with the
necessary code.

Hope this helps.
John
Project MVP

 

[Steve Scott]

Thanks,

Current formula is:-

Text1 = IIf([% Complete]=100,"Complete",IIf([Baseline
Finish]=ProjDateValue("NA"),"No baseline
Set!",IIf([Finish]<Date(),"Reforecast",IIf([Number1]>5,"R",IIf([Number1]>0,"A","G")))))

I only want this formula to be invoked if Text2 is equal to "0" or "1" or "2".

If Text 2 is not 0, 1 or 2 then I want users to be able to enter there own
values in Text 1.

Thanks in advance.