get #Error when add new task

[amin]

Hi

I want to copy data from Custom field Text11 to Text17 .

I add formula to Text17 :

IIf(IsNull([Text11]),'',[Text11])

the formula work correct for old task (befor I add the formula) , for
new task i get #Error in

Text17 field.

how can i copy the data without get this Error ?

***I add formula just to make Text17 Read Only, if you have another way
to make it read only it's will be great.

thanks

 

[Gérard Ducouret]

Hello Amin,

Your formula works fine for me, as well for old and for new tasks ... !

Gérard Ducouret

 

[amin]

thank you

Can you show me step by step how you add the formula ?

I"m using Project Profissional 2003

1 - Tools->Customize->fields
2- Choose Text 17 and click on the formula radioButton and click
"Formula" Button
3- write IIf(IsNull([Text11]),'',[Text11])
4-click ok

the formula copy the exist data , when i write new task by enter the
task name , i get #Error in text 17