How about WEEKDAYDIFF({defaultBaselineTask}.{plannedCompletionDate},{actualCompletionDate}). James Bender Jackson/JTS

If I'm reading what you want correctly, you should try using a TASK report with a column for "Default Baseline Task: Planned Completion Date" and a field for "Actual Completion Date". I believe the default baseline task object points at the most recent baseline taken by default. James Bender Jackson...

For anyone looking to adapt the Agile tool set, this idea to be able to implement custom statuses on the Kanban/iteration boards will be huge. Custom workflows are a must for Agile. If you get a chance, please review and upvote: https://support.workfront.com/hc/en-us/community/posts/360007359174-All...

At my company, we use the API to pull all Workfront data into a central relational database that closely mirrors the Workfront objects' underlying data structure, but also has some helper tables and helper columns to make some of the more complex relationships easier to query. In this way, we pull d...

I've been able to do this outside of Workfront using the API. You can get a list of all Journal Entry objects where the status of a time sheet has changed. The URI looks something like the following (obviously you can add more logic to filter out different time sheet profiles, statuses, or etc based...

The easiest way to change the queue topic on an individual item is by creating a report (possibly prompted) that includes Queue Topic Name as a column. A report is better than a view because if you view the issues on a particular project, you can only set a queue topic name that exists on that proje...

The thing that stands out to me is the camel casing. Should be: setWorkUnit, setWorkRequired, setActualWorkRequired, setPlannedCost, etc... Second thought is that if you are creating a new task, you need a column named isNew and the data row to be 1. James Bender Jackson/JTS