This works much better Doug. I figured it was something to do with the LEFT statement and I did not realize it was only testing the first 3 characters of the field. Thanks so much for your expertise and responsiveness. ELC is grateful to you. Cheers, Steve Steven Hirsch The Estee Lauder Companies In...

Hi Heather, Here's the code I am working with now in my version of the calculation field "Status History". LEFT(IF(LEFT(Status History,LEN(IF(ISBLANK(Status),"-",Status)))=Status,Status History,CONCAT(Last Updated By.Name," - ",(IF(ISBLANK(Status),"-",Status))," (",$$NOW,") | ",Status History)),2000...

HI Heather, Ah, there's the rub! I was trying to embed the Status translation to English directly in the Status History field. While that may be possible I like your method and will employ it. Thanks for sharing!! Cheers, Steve Steven Hirsch The Estee Lauder Companies Inc

HI Heather, Would you be able to share the final calculation you got working on this? I am having trouble with the positioning and format of the "status in english" IF statement translations of the root status codes. Thanks in advance. Regards, Steve

When I deactivate users they still remain on Staffing "People" lists in queue projects, projects, templates, groups and other objects. This irritates and causes confusion for project managers who see rights being passed along to deactivated users in the update audit trail on their new projects. I wo...

Hi Aileen, Just presenting a contrasting perspective here: I see you have 235 users in your People list. We have over 1700 users so far and if my list defaulted to all users it would take much longer to load my list, especially if I have a default grouping selected. When there is a default of 100 us...

HI, Please vote this idea up: https://support.workfront.com/hc/en-us/community/posts/360028770453-Need-list-of-Proofs-user-needs-to-Review-not-Approve We need Workfront to finally add back a list tab that shows a user the proofs they need to Review even if they are not an approver. The Document Vers...

The Home area as well as Document Version reporting needs to have the ability to filter out all the proofs a users is tagged to Review, even if they are not an Approver. The My Work area had this but the Home area never received this feature and ther are no reporting options to show a user their pro...

I really want to be able to use Collections of custom data more but am hampered by the inability to sort and control the output of a collection or to SUM up custom data in a collection or conditionally format the results.

HI Eric, I like this idea and voted it up. To get around this I have sometimes assigned the task to a team containing all users I want to be notified via the "Work Item Request to Team" notification. Then, in addition to the team, I also assign the specific Primary Assignee so that they get anothe...