Proposal

S

Senbag

I am trying the following scenario in Enterprise custom fields.

I have two custom date fields "_210_Inception Phase Start" and
"_241_Transition Phase Finish" in project level. these dates will be entered
by the user during the proposal. I am trying to create a third number custom
field "NoOF Days" with following formula to calculate and populate the number
of days between the above two date fields.

this the formula I used:

IIf([_210_Inception Phase Start]<>"NA" Or [_210_Inception Phase Start]<>""
Or [_241_Transition Phase Finish]<>"NA" Or [_241_Transition Phase
Finish]<>"",0,(ProjDateDiff([_210_Inception Phase Start],[_241_Transition
Phase Finish])))

Since the dates fields are empty or NA at the beginning, I have used the
above formula.
After saving this above field, I tried to create a proposal. the new field
"NoOF Days" is not showing up in the PWA but it shows up in Project pro
Project Information.

If I take the formula out of this field, it shows up in the PWA when i
create new proposal.

What I am doing wrong?

Anyhelp on this appreciated.

Thanks
Senbag
 
D

Dale Howard [MVP]

Senbag --

You are not doing anything wrong. In Proposals, users see only those fields
in which they can enter or select a value. It does not display fields that
contain a formula. I know of no way to force a Proposal to display a
calculated field. Hope this helps.
 
S

Senbag

Dale,
Thank you very much for your reply.
Senbag
Dale Howard said:
Senbag --

You are not doing anything wrong. In Proposals, users see only those fields
in which they can enter or select a value. It does not display fields that
contain a formula. I know of no way to force a Proposal to display a
calculated field. Hope this helps.




Senbag said:
I am trying the following scenario in Enterprise custom fields.

I have two custom date fields "_210_Inception Phase Start" and
"_241_Transition Phase Finish" in project level. these dates will be
entered
by the user during the proposal. I am trying to create a third number
custom
field "NoOF Days" with following formula to calculate and populate the
number
of days between the above two date fields.

this the formula I used:

IIf([_210_Inception Phase Start]<>"NA" Or [_210_Inception Phase Start]<>""
Or [_241_Transition Phase Finish]<>"NA" Or [_241_Transition Phase
Finish]<>"",0,(ProjDateDiff([_210_Inception Phase Start],[_241_Transition
Phase Finish])))

Since the dates fields are empty or NA at the beginning, I have used the
above formula.
After saving this above field, I tried to create a proposal. the new field
"NoOF Days" is not showing up in the PWA but it shows up in Project pro
Project Information.

If I take the formula out of this field, it shows up in the PWA when i
create new proposal.

What I am doing wrong?

Anyhelp on this appreciated.

Thanks
Senbag
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top