custom fields

[Peter]

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

 

[Jonathan Sofer [MVP]]

I think you will have to use macros to enforce this kind of entry.