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

HI David, Do you know if there has been any progress on this? I am looking to report on a history of changes to the Due Dates on key tasks. I am playing around with the Parent Journal Entry fields but wonder if anyone has built a nice report or has written text mode to show a history of Due Date cha...

Hi Christina, I think that all you need to do is create a dashboard with a Milestone report in it and then place that dashboard into a custom tab in your project or layout template and then that Milestone report will show only the project that the dashboard is placed in. Try it and let me know if yo...

Not seeing any of my old tickets, only new ones. I agree with all the issues posted here and hope there are fixes in play. Thanks, S Steven Hirsch The Estee Lauder Companies Inc

Just taking a stab... Could this possibly work? Assigned To ID=FIELD:Assigned By ID Assigned To ID_Mod=notin Regards, Steve Steven Hirsch The Estee Lauder Companies Inc

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...

I always liked the "feature" that custom data in task reports and in the plan view were not subject to the Mandatory flag set on the custom form. I'm bummed to hear that there is now a "cannot be null" error alert when exiting these fields inline. Steve Steven Hirsch The Estee Lauder Companies Inc