Hi, Has anyone been able to use text mode to group by project name (or ID) on a baseline task report? I tried the below as a starting point, but it is zero value group.0.linkedname=task group.0.namekey=view.relatedcolumn group.0.namekeyargkey.0=task group.0.namekeyargkey.1=Project ID group.0.valuefi...
I am needing to develop a report that will list each of the associate's listed in the "Resource Manager" field at the Project level, but am finding it more difficult than I thought. When creating a new "Project" report, Resource Managers shows us as an option for columns, but not for Grouping. Ide...
Hi All,I have a Workfront Search module in Fusion that searches for projects thatare in portfolio Xand were entered by user A or user Band don't have status X or Y or Zand have the External Ref ID field populatedI would like to achieve the same using the Workfront Custom API Call module. So I tried ...
Hi All,when I create / update a Workfront record via the WF API, I am expected to set the values of custom fields. I wonder what is the best practice method for populating drop-down custom fields.I know that I can populate the field by providing the "value" of the custom field option, for example:{ ...
Hello, I've built a Document Version report that provides me with the version # a proof was on once it reached 'Approved' status. I want to add one more column in my Details tab that tells me what Proof Workflow Template was used. I was in the API explorer and saw workflowTemplate was a field availa...
Need help to write a Report to capture duration (planned v actual) from project start to a specific task name that contains "Design Lock".The task "design lock" is used in all projects, but it's used in different templates has different predecessors.I assume I would run a Task report, but can't find...
Has anyone noticed lately that when you "delegate" approvals when someone is OOTO it works the first day, but then once that date has passed and it's their second day out, the delegate cancels itself and doesn't work anymore? We have used this for a few years and only last week did we realize it's n...
In our organization, each business unit (BU) has its own portfolio. Within these portfolios, programs are organized and aligned to the respective BU. However, is there a solution for a program to span across multiple BUs—essentially, for a single program to be associated with more than one portfolio...
I'm currently exporting the audit log and noticed that the date and time format in the exported file differs from how it's displayed within the instance. I've attached a screenshot showing the comparison between the two formats. I've tried a couple of times in excel using Text to Date and custom for...
Hi, I have a report with 3 level of OR statements. Example below.Field1_Mod=isnullname=Task 1name_Mod=cicontainsOR:1:Field1_Mod=isnullOR:1:name=Task 2OR:1:name_Mod=cicontainsOR:2:Field1_Mod=isnullOR:2:name=Task 3OR:2:name_Mod=cicontains But on Field 1, I want to do an additional check to exclude the...