Reporting Challenge: | Community
Skip to main content
J
JaneSt1
Level 2
October 2, 2020
Question

Reporting Challenge:

  • October 2, 2020
  • 2 replies
  • 581 views

Mgmt would like to have Rush and Super Rush defined by two task differentials.

  • Super Rush would be any project that is final due (Milestone) within 3 days of project opened/converted (Project Actual Start)
  • Rush would be any project with R1 (design) or CC1 due (Milestones) to partner within 3 days of project opened/converted. (Project Actual Start)

My initial though is to filter for these tasks, group by project and then conditionally format for Rush/Super Rush... Second thought to put calcs on custom forms (milestone calc on project?).

Also feeling like there might be a simpler solution I am not seeing.

Ideas?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    S
    SheilaSh
    Level 2
    October 3, 2020

    My initial thought because it seems easy, would be to add it to the custom form and create a report from those selected options.

      imgrund
      Adobe Employee
      imgrundAdobe Employee
      Adobe Employee
      October 5, 2020

      Hi - here is a Calculation for a task custom form that can tell you if the due date is within 3 days of the Project's Actual Start Date. You could use conditional formatting for coloring to make Final Due milestone a different color.

      IF(DATEDIFF(Planned Completion Date,Project.Actual Start Date)<3,"Yes","No")

      Hope that helps.

        Terms & ConditionsAccessibility statement

        Loading footer...