Hi All, In a task report, is there a way to pull in the predecessor's planned completion date for a cross-project predecessor? I'm not sure how to trace back across the projects. Thanks, Jen Jennifer Gulledge Elkay Manufacturing Company Inc

Hi Everyone, I'm trying to use a working calculation in a project report in a custom field calculation for a task report, and I can't get it to work. Here's the working formula from the project report: IF({templateTask}.{ID}="5bede5ae0001bac68e537b9f306bb95c"||{templateTask}.{ID}="5bedfaf100082d0ed6...

Hi All, I have a project report that I'm having all kinds of strange issues with. The report displays the milestones with the Targeted Completion dates from the initial business case (custom form), the dates from the default baseline and the current dates (see attached). Initially, I had trouble get...

Hi All, I'm looking for some help on a task report. I'm looking to group the tasks by the Home Team (in addition to Progress Status and Project Name). I used text mode (syntax below). The correct Home Team shows up on my report Details tab; however, when I pull the group into a Chart as the X axis, ...

Hi all, I've got a project report that pulls in the milestone planned completion dates from the tasks with milestones using the following - i.e.: column.20.displayname=Concept column.20.listdelimiter= column.20.listmethod=nested(tasks).lists column.20.sharecol=true column.20.textmode=true column.20....

Hi all, I have a calculated custom field to show the number of tasks coming in the Next 0-15 Days, 15-30 Days, 31-60 Days and Over 60 Days. I'm pulling this into a bar chart to show stacked statuses for those buckets. The problem is the columns are not ordering correctly. 15-30 Days is first, follow...

Hi all, I'm trying to create a chart that will show how many tasks are coming in the next 15 days, 15-30 days, 30-60 days and more than 60 days. I'm stuck on the value expression for the grouping. Here's what I have: group.0.linkedname=direct group.0.namekey=plannedCompletionDate group.0.valueexpres...

I'm trying to create a report that will group the tasks of a project by the role assigned. I tried to group by Assigned To -> Name, but nothing populated. I also tried to group by Assigned To -> Role ID, but the same - nothing populated. I tried to group by Task -> Assignments, which does populate t...

Is there a way to restrict a custom form to only show up under one Request Type? I have a custom form that I'd like people to populate if they're opening up a Change Order, but not if they're opening up an Issue or Request. Any one able to do this? Thanks! Jen Jennifer Gulledge Elkay Manufacturing C...

Hi All, I'm trying to create a calculated field on a custom form that subtracts one custom field from another. Is this possible? I'm using SUB(field name,field name), but it doesn't accept it. If I use actual Workfront built in task fields, the formula is fine with the same syntax. I'm assuming it's...