Solved

Hi Community, I have a question about a time difference calculation in Planning. I have a field called End Date and i want to calculate the weeks until this End Date in T-weeks. I used this formula with the intend to receive the following results: T-6, T-4, T-0 etc., but for some reason the $$TODAY makes issues in the formula field for Planning, since I am either getting T-0 for all calculations/data variations or no results at all.Any thoughts? Workarounds? Tipps?I already tried the following calculations:IF({Date End}>$$TODAY,CONCAT("T-",ROUND(DATEDIFF($$TODAY,{Date End})/7)),"T-0") IF({Date End}>$$TODAY,   CONCAT("T-",ROUND(DATEDIFF($$TODAY,{Date End})/7))) CONCAT("T-",ROUND((DATEDIFF($$TODAY,{Date End}))*-1/7))DATEDIFF({Date End},$$TODAY)ROUND(DATEDIFF({Date End},$$TODAY)/7)CONCAT("T-",ABS(ROUND(DATEDIFF($$TODAY,{Date End})/7)))WEEKDAYDIFF($$TODAY,{Date End}) Thank you for any thoughts in advance.

Hi everyone, We are in process of shortlisting vendor for Website translation. Are there any recommendation on the same.Leads are much appreciated. Thanks,Poovitha S

Hello Community! I was wondering if anyone ever had any luck bringing in the details from the updates section into a report. And not the last update note, but for example, if someone changes the status of a project or something similar. We are trying to capture what the last update made was to a project. Thanks in advance!

I'm working on an EDS site using Universal Editor and need to offer authors a dropdown with dynamic list. This list can be sourced from either an ACS Commons list or a JSON feed from an API. I'm looking for an out-of-the-box (OOB) solution for this functionality to avoid developing a custom Universal Editor extension.

Is this something new? I don't recall seeing it mentioned in quarterly updates.  

Hello, I need to be able to display the offer content in the email body and the associated terms & conditions of the offer at the bottom of the email, in the footer section. The terms & conditions are very specific to the offer and vary from offer to offer. How can I achieve this through offer decision? Please tell me if I am going in the wrong direction but I am thinking of using 2 offer decision with exactly the same thing (offer collection, decision rules etc) but just different placement. Does this guarantee that the content and terms & conditions will be of the same offer? There might be another way to achieve but thought will share my logic. Any help on this would be much appreciated.  Thank you!

We have several request queues that route requests to the correct project manager. Each queue is for a different project scope. We want to keep the name of the original queue in converted projects and in projects duplicated from the converted projects.The standard converted request fields are deleted when a project is copied which makes sense. Can I add some kind of calculated field to hold the name of the queue when the project is duplicated? 

Hi, Is it possible to capture personalization/conditional content in a typology rule? Take the following typology rule code which executes "at the end of analysis" for the alertAssignee delivery template.logInfo(delivery.content.text.source) This will return the following, which is the content of the alertAssignee delivery template."<%= dataSource.message %>"However, when an alert is sent out, this <%= dataSource.message %> can become many different things. How can we capture this in the typology rule?

Hi all, I am new to the Workfront product. Do we know if it is possible to integrate it with CDP & AJO, I do believe so it can be done via API or AEP connector. Curious to here all your experiences. Regards,Celia

How can we set a default Request Queue for a user or team, so they only see the queue relevant to their operations?

Hello all Is it possible to build a board that looks and functions like the Legacy Agile View? Thanks Bill 

Hello,When a project is completed in Workfront but then moved back to "current" (re-opened) again, the completion date remains. Is there a way to turn that off so that the completion date is removed when the project is re-opened?

We're currently working on a refresh of our WF training.  Some users have expressed a desire to track personal work tasks.  I thought I'd make them a guide for entering these tasks on the Priorities tab.  Some users have explored Priorities while others have not--the latter still have the intro message and the 'Discover the new work list 🎉' task in a personal project ('FirstName LastName's Tasks').Is there anyway to locate these projects in the system?  I can log in as individual users and navigate to the projects (if the discover task is still in Priorities); as an admin I can still view the project while I'm no longer logged in as the user.  However, I've been unable to run a report that lists these individual projects (I even added myself as a user for one of the projects in the sandbox preview, but I still can't report on the project).

I am "trying" to create a calculated field to concat fields based on multiselect fields. I can get my statement to work if there is just one criteria. but how do I/is it possible to get the and statement to work between 2 fields. I found some examples that are kind of looking like what I want, but when I try and add the && into the text the wheels fall off. Here is where I ended up around the time I was pulling my hair out. Any help would be greatly appreciated. IF(CONTAINS("Meta (FB/IG)",{DE:GF Paid Media Type}&&”Static Image”,{DE:Duration}),CONCAT({DE:GF META Story Static Specs},"\u000A",{DE:GF Copy for TIKTOK ASSETS},"\u000A",{DE:GF Meta Copy Specs}))

In my task view, I want to create a filter to compare two field values to determine which task lines to displayI want to compare the Task: projected Completion date and the Project: Planned Completion date.I want to display any task that has a task: projected completion date greater than the Project: Planned Completion date.I know I need to do this in Text mode.Can you tell me the text I need to create

Is anyone aware of a way to transfer ownership or a board? Even a possible workaround solution?

Hi All,We are trying to pull the data from Issue level custom form at project level but we are unable to do that.Can someone please help us with any calculated field syntax which can be used for pulling such kind of data? 

Is there a way to create and generate a report for how many times a Team tag is made in a Project or Tasks Updates message? In the report, I also want to add additional column fields to include information about the Project or Tasks.

I want to build a scenario that looks at a project's tasks to see if they are complete. The project can have up to 3 specific tasks with set names that need to be completed. Is there a way I can accomplish this using custom fields while still using an instant webhook event? Like something along the lines of Example pseudocode, I know there are some logic errorsIf 1,2,3 or 1,2 or 1,3 or 2,3 or 1 or 2 or 3 = CPL ; true ; false 

I'm looking for a way to trigger a warning or flag when a user attempts to create a project with a name that already exists in Workfront. The goal is to prevent unintentional duplication and maintain clean project naming across the system.I've explored using custom forms and calculated fields, but Workfront Core doesn’t seem to support real-time validation or lookups for duplicate detection. Ideally, I’d like a solution that alerts the user upon project creation or update—either via Fusion or a custom logic setup.Has anyone implemented a workaround for this, perhaps using:Custom fields + validation dashboardsFusion scenarios that monitor for duplicate namesText mode filters or reports to highlight issuesAny guidance on the best approach

Hi All, Is it possible to create a fusion scenario to remove the product for user in Admin console using fusion ? Thanks in advance

Hi,  I have a project report that is pulling in the tasks for each project, and I'd like to show the percent complete of each task. Right now I can only get the percent complete of the entire project.  Any tips appreciated! Here's the logic I'm using: aggregator.displayformat=asPercentaggregator.function=CNTaggregator.namekey=percentcompaggregator.valuefield=percentCompleteaggregator.valueformat=asPercentdescriptionkey=percentcompletedisplayname=Uploaded to Salesforcelistsort=doubleAsDouble(percentComplete)namekey=percentcompquerysort=percentCompletetile.attribute.height=12tile.name=component.percentcompletelistviewtype=tilevalueexpression=IF({templateTaskID}="6849bcfb0002112142720f076aaa35d9",{percentcomplete})valuefield=percentCompletevalueformat=asPercentwidth=80   

Can we set a workflow for statuses wherein we can define what are the next available statuses based on current selected status? For e.g.: 

Hello,The client would like to see a proof report that includes the following information:Approver nameProof progressStage the user belongs toDecision statusThey also want to understand whether an approver is pending due to the proof being on hold in a previous stage. Essentially, they’re looking for something that closely mimics what’s shown on the Proof Workflow page.Here’s an example of the desired format:Option 1 – All stages with SOCDProof Status: Pending (already included in the report)Proof Review Status: Only ApproversStage 1: User name – ApprovedStage 2: User name – Pending – Sent / OpenedStage 3: User name – Pending – Not SentProof Owner: User name (already included in the report)Additionally, they would like to filter the report by role, so that only Approvers are shown—Reviewers should be excluded.Is this achievable?Best regards,Maria

I want to create an Agile Team(SCRUM) with Iterations & Sprints for the development team who assignments are there across the portfolio.I am able to switch the normal team to a Agile team, I can new story in the backlog or iteration but not able to see all the tasks that are already assigned to the team.  Can anyone help me understand the Agile team creation and its management? Thanks in Advance!