Adobe Workfront

Verifying On-Time Delivery logic in Workfront: same-day date comparisonsWe are implementing an On-Time Delivery KPI where work is considered on time if the Actual Completion Date is the same day or earlier than the Planned Completion Date.However, even when both dates appear as the same day in the UI (with different times), comparisons using <=, DATE(), DATEDIFF(), and DATENOTIME() sometimes return late.Is this expected due to Workfront storing DateTime values in UTC?What is the officially recommended approach for calendar-day-based SLAs in Workfront?What is the way to compare only date without time ?

I need to see a report of Tasks and Requests that do not have hours logged by every assignee on each task/request so that we can see what Tasks/Requests are missing hours for which assignees.There’s a thread here that identifies a way for an individual user to see their own Tasks that have not been assigned hours, but I can’t seem to find anything that shows how to see multiple users who do not have assigned hours. Any advice is appreciated.

Hi,I have created a calculated column in an Adobe Workfront report using text mode, and the column displays correct numeric values (0/1) in the report grid. However, this column does not appear in the “Values” dropdown when configuring a chart for the same report.What I have done Report Type: Project / Task Report Created a calculated column using text mode: The column correctly shows: 1 for on-time 0 for late Attempted to use this column in: Pie / Column / Gauge charts Different “Summarized by” options (Average, Sum, Count) Issue The calculated column does not appear in the Chart → Values dropdown. Native numeric fields and custom number fields do appear correctly. Questions Are calculated columns (text-mode columns) supported as chart values in Workfront? Is there a known limitation that prevents calculated columns from being used in charts? Is creating a custom calculated field on the object the only supported way to chart this data?

I thought this would be easy, but so far it hasn’t worked. We have a typeahead field called ‘Associated project’ that lets the user select another project in the system.  I want to add a report/dashboard to the left panel of every project in the system that will show all the other projects that list the CURRENT project in their ‘Associated project’ field.  The report works perfectly if I set it up with a prompt, but I can’t get it to work automatically when viewed within the project.Is there a way to use text mode to filter the report based on the current Project ID?  Copilot says that this text mode expression will work, but so far it hasn’t, and I think it’s just hallucinating solutions:!--scriptorstartfragment-->parameterValues:Associated Project=$$PROJECT.IDparameterValues:Associated Project_Mod=eq!--scriptorendfragment-->

I'm receiving an error when uploading documents. (Failed to upload file)This is happening to my zip file that is 1.77 GBI never used to get errors like this but for about the last month have been having this happen all the time.

I’ve added a custom expression to projects that calculates the fiscal quarter and year in which the project was created. I’d like to use this for past AND future reporting. Currently, all projects display “N/A” so I’ll need to recalculate the expressions of at least the past year’s worth of projects. I tried to use the bulk edit method described in the documentation here, but the UI is different from the screenshots, and I don’t see the “recalculate expressions” checkbox. Does anyone know of another way to do this, or if I’m performing the steps incorrectly? I don’t have access to Fusion, so I can only do this within Workfront itself. Thank you for your help!

Hi,Why we cannot add a project related (Project ID) field in user object report.Is that a workfront native or is there any option to add.

In my instance, we have a frequent question/point of confusion that comes up with our team and I’ve never quite been able to come up with a good way to explain it to people that makes sense to them. I’m wondering if this is a common confusion, and if anyone has come up with good teaching methods for it?  Scenario: We make a custom form for a new intake process, and a matching summary report for the team who manage the process to see all the records/data that are input on it. Over time, the process managers get used to using that report like Excel, and rarely have a need to open the Issue/Request record that’s behind it.Challenge: Sometime later, the process managing team have someone new join the team. That person is shown the report and asked to make some updates. They are unable to make the edits, which results in a support ticket to my team incorrectly asking for edit access to the report itself rather than the records it’s displaying.  The real issue is that the new team member was

I am trying to calculate On-Time Delivery % in Adobe Workfront using a Project report, but the percentage column is not returning any values.What I have done so far: Created a row-level calculated column to flag on-time completion:  IF(ISBLANK({actualCompletionDate}),NULL, IF({actualCompletionDate}<={plannedCompletionDate},1,0)) This column correctly returns 1 for on-time and 0 for late items. Added a second column to calculate the percentage using text mode:  valueexpression=SUM({DE:On Time Flag}) / COUNT valueformat=percent Added filters: Status = Complete Actual Completion Date is not blank Planned Completion Date is not blank Added grouping (Project Type / Team / Status). Issue: The On-Time Flag column shows values correctly. The On-Time % column shows no values (blank) even after grouping.  My question: Is there a supported calculated formula in Workfront to calculate On-Time Delivery %? Are COUNT or aggregation functions not supported in valueexpression for Project

Hi,Is there any possibility to add a field in the Columns section of a report that shows the number of projects created by a specific user in Adobe Workfront?I am specifically looking to display this value as a column, rather than only seeing it in grouping summaries.Context: Report types tested: Project Report and User Report Requirement: Count of projects created by a user Expectation: A numeric value displayed directly in a column Challenge: Calculated fields do not support aggregation (COUNT) across related objects. Text mode expressions using COUNT() do not return values. Question to the community: Is this functionality supported in Workfront? If not, what is the recommended or standard approach to display the number of projects created by a user in project report?

Hi Is there any option to calculate the count of Number of project created by user in calculated field on user report or is there any field that exists default to count the Number project in user object report.

When a user removes a custom form from an issue or any other object, the system updates area does not keep an audit trail letting us know that a custom form was removed. Need a way to know when a custom form was removed from a record and by whom regardless of the object.

I would like to be able to capture via a calculated field when custom text field has been changed. Current option is to look at the update feeds Update feeds captures thru Audit Text when a field change is reported in the update feed showing the before and after. Extracting thru text mode the Audit Text Entry date and making know which custom form field you are looking for and its corresponding entry date is nearly impossible.

Undo button available for system admins when designing/creating within a custom form, layout template, reporting, text mode. Please make this available when designing scenarios in Workfront Fusion as well. Why is this feature important to you - Eliminate unnecessary rework.How would you like the feature to work - Start by adding the undo button in custom forms, so if you delete a field by accident you can undo the action.Current Behaviour - There is no undo button

Hi team,I use Power Apps to automate many of the tasks that we have as part of our projects. To help users access the app direct from Workfront, I have created a custom calculated task field that stings together a URL that will open the app on the page needed with the project loaded. The issue is, the URL is long and takes up a lot of room. Is there a way I can have this URL behind text such as "Go To Power App". Like you would if you were doing HTML (<a href="url">Go To Power App</a>)The calculation I am using is...CONCAT("https://apps.powerapps.com/play/e/10ce04bd-ba11-e353-9800-82af01dab1cb/a/f31e71a2-b125-4314-bcd7-511edf6fd56f?DeepLink=",{DE:SAAT Screen Code},"&PID=",{project}.{referenceNumber})Can I display this URL on each task as  "Go To Power App"? Thanks for your help. 

I am planning to refine and standardize the marketing asset types and associated deliverables used in Workfront. If I delete an asset type, will that fall off past project reporting? Is there a way to just archive an old option on a field and not completely delete?