Expand my Community achievements bar.

StevenHi2
StevenHi2
Offline
Type
  • All
  • Questions
  • Discussions
  • Ideas
  • Blogs
Filter by user contributions
  • 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...

    Type

    Questions

    Views

    251

    Likes

    0

    Replies

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

    Type

    Questions

    Views

    193

    Like

    1

    Replies

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

    Type

    Questions

    Views

    2.4K

    Likes

    0

    Replies

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

    Type

    Questions

    Views

    2.4K

    Likes

    0

    Replies

    0
  • 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

    Type

    Questions

    Views

    2.4K

    Likes

    0

    Replies

    0
  • 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

    Type

    Questions

    Views

    2.4K

    Likes

    0

    Replies

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

    Type

    Questions

    Views

    414

    Likes

    0

    Replies

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

    Type

    Questions

    Views

    320

    Likes

    0

    Replies

    0
  • 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

    Type

    Questions

    Views

    1.2K

    Likes

    0

    Replies

    0
  • 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

    Type

    Questions

    Views

    827

    Likes

    0

    Replies

    0
Top badges earned by StevenHi2
Customize the badges you want to showcase on your profile