HI, Does anyone have a slick method or expression for reporting on the percentage of Active projects in the system that are Progress Status=Late. I would love to have a Gauge chart to show the percentage of projects that are late. Thanks in advance for any ideas. Regards, Steven Hirsch The Estee Lau...

HI All, I put a new Task History report together with some calc fields to create a shared column that displays a block of dates that some of my users are finding valuable in tracking task history and turnaround. Thanks to Narayan for the shared column instructional video. I am looking for any feedba...

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