Prev: Selecting time-scale
Next: HELP!! Gantt Chart Printing not Working
From: Peter on 10 Nov 2009 15:00
Anybody have a quick solution for the following:

Is this possible to write a formula to make it work as such?:
One
If the EVM method (text2) = 2C then the number field should only allow
the person to enter 50 or 100.
If the EVM method (text2) = 1 then the number field should only allow
the person to enter 100.


Two
If the EVM method (text2) = 2C then the duration cannot exceed 40days
If the EVM method (text2) = 1 then the duration cannot exceed 20days
From: Jonathan Sofer [MVP] on 10 Nov 2009 15:23
I think you will have to use macros to enforce this kind of entry.


"Peter" <gugliupj(a)gmail.com> wrote in message
news:d5c34c83-b678-43b2-99d7-b0ebe35ad073(a)j19g2000yqk.googlegroups.com...
> Anybody have a quick solution for the following:
>
> Is this possible to write a formula to make it work as such?:
> One
> If the EVM method (text2) = 2C then the number field should only allow
> the person to enter 50 or 100.
> If the EVM method (text2) = 1 then the number field should only allow
> the person to enter 100.
>
>
> Two
> If the EVM method (text2) = 2C then the duration cannot exceed 40days
> If the EVM method (text2) = 1 then the duration cannot exceed 20days

 | 
Pages: 1
Prev: Selecting time-scale
Next: HELP!! Gantt Chart Printing not Working