Need help! I am trying to do an approval process, that will be triggered automatically from process builder. The problem I have, is picklists. I want the approval to go out automatically on the condition of specific change in picklist. "Forecast Category" 1,2,3,4,5 . If Opportunity is currently in category 4, users can change is to 5(close won), but if they want to change for 3,2 or 1, record is sent for approval. I tried playing with Validation rules, to prevent users changing, but Validation triggered some other unrelated processes(( and for Process builder and approval process I can not find a way. Thank you!!!
Did you try using priorvalue to check what it was before and what it is now?
Something like this should work for the entry criteria where you check if it used to be 4 and if it is now 3,2,1.
PRIORVALUE(ISPICKVAL(Forecast_Category__c, "4") && ( ISPICKVAL(Forecast_Category__c, "3") || ISPICKVAL(Forecast_Category__c, "2") || ISPICKVAL(Forecast_Category__c, "1") || )