I need help.
I am trying to figure out how long approver takes to approve/deny a record.
To accomplish this,
First I created a field on the object and added workflow flield update.
- New Field created: Name is "Approval Submitted" (Date Field)
- New Workflow:
---Evaluate the rule when a record is: Created
---Rule Criteria is when Partner Deal is Checked
---Field Upste: Approval Submitted Date (Field Data Type DATE)
---FORMULA VALUE TODAY()
Second Step is to show how long Approval Request is pending, I went into the report and created a formula field.
Since above step didn't worked, I tried to create a formula field but couldn't know how to grab Submitted Date from the report.
There are over 5 new records were created had Partner Deal Checked and no field update was made on the Approval Submitted Date field.
9 risposte
Hi,
Thank you Deepak for your suggestion. I followed your directions and when I added the Formula "TODAY() - Approval_Submitted_Date__c" then an error message appeared when clicking on the checkSyntax button.
--Error: Field Approval_Submitted_Date__c does not exist. Check spelling.---
Can you help me with this?
