I am trying to create a validation rule that will require users to select a value from the picklist "Revenue Type" whenever the opportunity stage changes to "Bell". I am having trouble making this work correctly. Here is my current attempt at a validation rule:

AND( ISPICKVAL( StageName, "Bell"),   ISPICKVAL( Revenue_Type__c, "0"))

(but this doesn't seem to work since I can still change an opportunity to the "Bell" stage without having to select a Revenue type before saving).

Any help would be much appreciated!!

I am trying to create a validation rule that will require users to select a value from the picklist "Revenue Type" whenever the opportunity stage changes to "Bell". I am having trouble making this work correctly. Here is my current attempt at a validation rule:

AND( ISPICKVAL( StageName, "Bell"),   ISPICKVAL( Revenue_Type__c, "0"))

(but this doesn't seem to work since I can still change an opportunity to the "Bell" stage without having to select a Revenue type before saving).

Any help would be much appreciated!!