Ask Search:
Cheryl NormanCheryl Norman 

Picklist or Workflow?

Good Day All,

I have a picklist value that has one selection Duplicate Opportunity on closed lost reason field.  All I want to do is (without building a VF page) is if my reps select Duplicate Opportunity then they must enter the Duplicate Opportunity Name in the blank text box below.
     Or
Should I just do a simple checkbox that evaluates to true that when the rep checks the box the next step is to fill in the duplicate opportunity name before the record is saved. 
 
Best Answer chosen by Cheryl Norman
Amit SinghAmit Singh
Try below
AND(
   TEXT(Reason_Lost__c) = 'Duplicate Opportunity',
   ISBLANK(Duplicate Opportunity Name);
)

Note: - Use Correct API name and use insert field option to Select the Field.

All Answers

Amit SinghAmit Singh
Try below
AND(
   TEXT(Reason_Lost__c) = 'Duplicate Opportunity',
   ISBLANK(Duplicate Opportunity Name);
)

Note: - Use Correct API name and use insert field option to Select the Field.
This was selected as the best answer
Amit SinghAmit Singh
++ P.S- Need to Create Validation Rule
Cheryl NormanCheryl Norman
Thank You Amit  I should add the formula to the checkbox then create a validation rule to force the rep to fill in the next step
 
Amit SinghAmit Singh
Yeah Sure