Hi All, How do we set up workflow rule / Custom field which can calculate the number of days a request has been sitting in a particular phase, for example I am trying to figure out the number of days a RISK/ISSUE has been staying in Active state
There’s a few ways for this depending on how often it’s needed
- If it’s a once off, or you only need to do this infrequently I’d just be using the Change History, and add a filter for “Field Name” then filter on the Active state, and you can see the changed on date
- If you need to know JUST the number of days in the current state - then create a custom API only number field for State Start Date, set that on state change in workflow rule, then another custom API only number field to set that State Day Count via workflow rule which does a datediff on the State Start Date and today.
- If you need this number regularly, and want a “Number of days in X State” then I’d create a custom API only number field for each State I needed to track. Then create a workflow rule that uses evaluation criteria something like “(IsChanged($State) && $State <> null)”. Then have a bunch of “Conditional Action List” IF statements that say if Active, then set each one and calculate all the days. (kind of like a recursive B above)
Hope this makes sense. Let me know if you have any other questions.
Hi Mayank - Andy gave excellent advice! I would add to that you can have this counter with the custom field that Andy mentioned (days at Active) and I would use a SWFR that runs over night. If the case is in an Active state, I would have the SWFR count the days at Active up by one. If the case state is not in an Active state, the SWFR can clear the count field entirely or skip over that record as the conditions to run do not apply.
Hi
Reply
Planview Customer Community
Already have an account? Login
Planview Customer Community
No account yet? Create an account
Login with SSO
Login with Planview AdminEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.