
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개

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