Hi all,
I'm struggling with my formula field (data type: number).
First, I have a WF rule to calculate the age my case at status: Waiting for customer feedback. If the status changes to another one, I want the formula to pause and then restarts when the status comes back to Waiting for customer feedback. This is my WF rule :
AND (
ISPICKVAL( PRIORVALUE(Status ), "Waiting for customer feedback"),
ISCHANGED(Status ))
And this is my WF Action field update Formula that i want to set in Days, hours and minutes. But it retrieves only Days as shown in attachement. Please, help me:
IF( ISBLANK ( PRIORVALUE( Waiting_for_Customer_feedback_Age__c )),0,PRIORVALUE(Waiting_for_Customer_feedback_Age__c))+ (NOW() - Waiting_for_Customer_feedback_Start__c )
2 respostas
Hi Ibrahim,
I'm not sure how you would like to display Days, Hours, and minutes on a Number field. Perhaps you would like to a Text field instead with a format: "X Days X Hours X Mins". Take a look at the "Finding the Elapsed Time Between Date/Times" portion of the article below:
https://help.salesforce.com/articleView?id=formula_examples_dates.htm&type=0
Thanks!
