Expand my Community achievements bar.

Interested in getting an Adobe Workfront certification? Don't miss our AMA on June 10th, where our experts will be available to answer any questions you may have about getting certified!

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Reporting Challenge:

Avatar

Level 3

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?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 2

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

Avatar

Level 10

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.