Hi Anthony, I'm well acquainted with how timezones work in Workfront but I haven't even had an issue with the system default timezone changing on its own. There was a bug once where the timezones of schedules would change when you edited another setting on the schedule, but that was fixed a couple o...

Hi Melanie, Not sure how to implement this via python, but the basics should be as follows: https:// insertyoururl .my.workfront.com/attask/api/v8.0/project/search?name= Test &name_Mod=cicontains&fields= status,name,progressStatus &apiKey= yourapikey Using an API key, there is no separate login step...

One more piece of the puzzle is that you can report on the results of the approval process (rather than just the tasks which are currently awaiting approval. You can add this text mode field to a task report: displayname=Approval Status listmethod=nested(approverStatuses).lists textmode=true type=it...

Hi Jamie, So far, I've set it up so that Power BI Desktop connects directly to Workfront's API as a web data source for each Workfront object type I want, using API queries I've written to give me the various fields I want. For each object type (projects, tasks, assignments etc) it drags down the re...

Hopefully this collections text mode column will help: displayname=Successors listmethod=nested(successors).lists textmode=true type=iterate valueexpression={successorID} valueformat=HTML Note that this will only show the IDs of the successors. Normally with a collection you can reference further th...

I'm actually using Microsoft Power BI with Workfront data. Like Tableau, there is no out-of-the-box Workfront connector for Power BI, however, much of the principles are the same. Most of the early reporting I have done has been based on manually exporting data to Excel from Workfront reports, then ...

Hi Tracy, Good question......we've just started using the CPI & SPI in some of our reports. I had also wondered about the fact that an SPI can show 1.00 but yet the project condition is At Risk or In Trouble. I don't know for sure, but my guess is that the SPI is effectively averaged at the project ...

For a different approach, you could look at doing something like we have done using an integration service (Azuqua) and email service (Mandrill-Mailchimp) to email your purchase orders from Workfront: Create custom fields to contain the PO-related data, including recipient email address info. ...

Just wondering why you need to rename 500 tasks on a weekly basis within this project? Perhaps there is another way to achieve the business requirement without needing to rename these tasks? If you can elaborate, someone may have a good idea. Another (fairly clunky) suggestion without using kickstar...

Just saw that system-wide widescreen is coming in 18.1! Woohoo! "https://support.workfront.com/hc/en-us/articles/115003927233#system-wide-widescreen-display">https://support.workfront.com/hc/en-us/articles/115003927233#system-wide-widescreen-display David Cornwell