- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi Nuria,
You might want to sit down for this one.
In my original design (having refreshed my memory), Current Status is a calculated parameter, with the following formula (noting that for Issues, there would likely be more entries):
IF(Status="NEW","New"
,IF(Status="INP","In Progress"
,IF(Status="HLD","On Hold"
,IF(Status="CPL","Complete"
,Status
)
)
)
)
When an edit is made within Workfront, there a number of steps that occur in a certain order, among which, resolving calculations is (in my mind) "after" the edits have been made, but "before" the record is fully saved. In my case (and, I suspect, @Greg Wilson‚ and the others on this thread), that certain order might (I now appreciate) be part of the reason the behavior we are seeing is as we desire.
In your case, however, since Current Status is instead a custom text parameter, I suspect it is being evaluated "as" the edits are being made, which in turn is causing the unexpected behavior you are observing.
So! Presuming that you have good reason to leave Current Status as a text parameter, I suggest you try this (or something similar):
- create a calculated parameter beside Current Status called "Current Status Calc"
- set its formula to "=Current Status", effectively pointing at the manually entered status
- edit your Status History custom calculated parameter's formula and replace "Current Status" with "Current Status Calc", thereby tapping into that special "after" edits but "before" sweet spot
- save everything and test
I look forward to hearing how you make out, and hope it does the trick.
Regards,
Doug