I am trying to create a validation rule on a custom object that prevents a specific status picklist value from being selected if a number field on the custom object is greater than a formula field on the Contact standard object. The formula field is a case function that looks at a separate picklist field and spits out a number like this but with more values:
CASE(TEXT(picklistfield__c), "A", 180, "B", 60, 100)
The validation rule I have currently looks something like this:
AND( ISPICKVAL(status__c, "Value"), Number field > formula field )
The problem I am running into is the formula field appears to always be set to 100 for the validation rule even if it's spitting out a different number for a given record. Is this intended? How do I rectify this?