I have a picklist field called - "Account management Stage" with picklist Values such as: Post-Kickoff Documentation Received and Status Report Updated
I also have a date field called : Actual First Status Report Update
How can I get the Actual First Status Report Update
date field auto-populated
With the Process Builder Criteria to trigger:
When the user toggle between Account Management Stages values "Post-Kickoff Documenation Received" & "Status Report Updated"
This is my formula:
AND(
ISCHANGED([Opportunity].Account_Mgmt_Stage__c )
,
OR
(ISPICKVAL([Opportunity].Account_Mgmt_Stage__c , "Post-Kickoff Documentation Received") ,
ISPICKVAL([Opportunity].Account_Mgmt_Stage__c , "Status Report Updated")))
Action:
Date Field "Actual First Status Report Update" is populated every time the "Post-Kickoff Documenation Received" or "Status Report Updated" is selected
Field :Actual First Status Report update
Type: Formula = Today ()
The above node in the formula doesnt seem to be working.
Any help here is appreciaited. thank you.