+ Start a Discussion
AnonTestQuestAnonTestQuest 

Validation Rule to make a field required

How can I make a field required only if a certain item is selected in a seperate picklist field on the same custom object?
Best Answer chosen by AnonTestQuest
AnonTestQuestAnonTestQuest
Those basically worked. I used:

And
(
 ISPICKVAL(Package_Status__c , 'GA'), 
 Knowledge_Article_Resource__c = NULL
)

for my rule and threw the error that said that field was required.

All Answers

yvk431yvk431
Try this:
AND(ISBLANK(TEXT(Field2)),ISPICKVAL(Field1,"Something"))

--yvk
Amit Chaudhary 8Amit Chaudhary 8
And
(
 ISPICKVAL( StageName , 'Closed Won'),
  ISBLANK( Amount )  
)

Please create a validation rule like above. 
Please let us know if this will help you

Thanks,
Amit Chaudhary
AnonTestQuestAnonTestQuest
Those basically worked. I used:

And
(
 ISPICKVAL(Package_Status__c , 'GA'), 
 Knowledge_Article_Resource__c = NULL
)

for my rule and threw the error that said that field was required.
This was selected as the best answer