Wondering if you could help me create a field that would give us the response time on Leads with business hours based on first activity. I created a formula field called First Activity Date/Time. I attempted to create a workflow to update this field when a called Last Activity Date not equal to NULL. The formula to update this field is Now(). The workflow is not working.
My thought was once I have this time stamp of the First Activity Date/Time, I would use this field in another formula field to calculate the response time. I created another field called First Response Time (Formula). The formula for this field is: (FirstActivityDate/Time - DATEVALUE(CreatedDate)) * 24. The other issue I am facing is that I need the number to reflect business hours.
Best,
Cat Cornejo
1 Antwort
Hi Cat,
This should help with your workflow: https://success.salesforce.com/answers?id=90630000000DTMfAAO
