Editable calculated custom field in project

[Gabriele]

Hi to all,
I would like to know if it is possible to create a custom field having
a default value calculated throught a formula, but I want the user to
be able to change the value of the field directly typing in the value
he wants.
Any suggestion will be very valued!!
Gabriele

 

[JackD]

No you can not, but if the value is a static value, you don't need to.

Simply use a value list.

select the column header
right click
select customize fields
click on the value list button
enter the value you want as default
check the "Use a value from the list as the default..." box.
Select the value
Click the set default button
check the "allow additional items to be entered into the field" button.
click OK.

Now if the value must be calculated you have to use two fields
Use Text1 for the user to enter a non-default value.
Use Text2 with a formula like this:

iif([Text1]="",(put your formula here),[Text1])

That way if text1 is blank it uses and displays the result of your formula,
and if text1 is not blank it uses and displays the value of text1.

-Jack