+ Start a Discussion
SFDC KeeperSFDC Keeper 

Conditional Formula Validation-

Based on a pick list in a case reason --Require two other fields. I need to have two other field required when the list box option Late to promise is selected in a custom field. Please supply a validation rule if possible. I cannot require on the page layout as other ooptions do not require this field Thank You

Message Edited by SFDC Keeper on 10-21-2007 08:11 PM

You can try this, assuming the other 2 fields are text fields, just replace Subject and Desc with your fields.
OR(AND(ISPICKVAL(Reason,"Late to promise"),LEN(Subject)<1), 
AND(ISPICKVAL(Reason,"Late to promise"),LEN(Description)<1))