Skip to main content
Topics#Data ManagementJodie Williams の質問
Jodie Williams (Camvac Limited) が「#Data Management」で質問
2018年3月7日 14:38

Validation Rule if field is populated, the picklist field must not be blank

Hi Everyone,

 

I have a rule that states if the opportunity is closed won the quantity field must be maintained, now I need to make sure that if the quantity field is maintained the correct unit of measure is selected.

 

I want my custom picklist 'Unit_of_measure' to be mandatory if there is a figure entered into the 'TotalOpportunityQuantity' field.

 

I've use this:

 

NOT( 

 

AND( 

 

ISBLANK( TotalOpportunityQuantity), 

 

ISBLANK(TEXT( Unit_of_Measure__c)) 

 

))

 

Which has made the field madatory when a figure is entered into the quantity but when I populate the picklist the error message doesn't go away, can you help please?  

 

Thanks,

 

Jodie 
4 件の回答
  1. Jodie Williams (Camvac Limited)
    2018年3月8日 15:03
    Hi Guys,

     

    Thanks for that.  For some reason the picklist isn't madatory now but actually one of my stakeholders has moved the goal post a little so I think I can do this a different way.  We will only be using one unit of measure.

     

    Thanks,

     

    Jodie
回答を記入...
0/9000