Is there a way to accomplish this with a workflow instead of a trigger? I would like to update a custom date field (Opportunity Stage Change) to TODAY() whenever the new opportunity stage is Cold OR whenever the priorvalue is Early Negotiation.Either way would work for me. I have seen a few solutions with trigger but I'm trying to get this done using either a Workflow or Process Builder.
Here is what I got for the workflow but I'm doing it wrong:
IF(ISPICKVAL( StageName ) = 'Cold', (IF(ISPICKVAL(PRIORVALUE( StageName ) , 'Early Negotiation'), Opportunity_Stage_Change__c = TODAY(), null),null)
I'm getting the following error, but I think there is a bigger problem with the logic/approach.
Error: Syntax error. Missing ')'