Solved

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!

I am using this calculation on a date field to calculate due dates. ADDWEEKDAYS($$TODAY,4) How can I modify this to exclude holidays so that they are not counted as business days in the calculation? My instance of Workfront does not have a holiday library so I would need to list them manually in the calculation and then likely update every year I would assume. Thanks in advance.

Is it possible to add a digital signature to a PDF that is attached to a request when the request has been approved? I assume Fusion would be involved, but I was wondering about how that works. Thanks! -Roy

Hi Community! This is a bit of a long shot but I am testing the tableau - workfront data connection via snowflake and I'm trying to build a few simple visualizations. Perhaps I'm just not familiar enough with tableau yet, but I am not understanding how to add custom fields from my data source if I want more than one field per object (two custom fields that sit on a task form for example) Maybe I just need more time with it and to be fair, I am a system administrator with no SQL experience, so maybe this is too technical for me, but I figured once I made the connection, it would be drag and drop, with a bit of a learning curve to navigate the data and how it's displayed. Has anyone had any luck building visualizations in Tableau yet where you have multiple custom fields across a few object types in one report / dashboard? I am lost and there's no documentation available. I do have a meeting with someone in my company who has more advanced Tableau experience next week, but

Does anyone has experience in Integrating Adobe Workfront with SAP Datawarehouse to retrieve data from Workfront and schedule batch jobs?I am specifically looking at API endpoints and detailed procedure in integrating it with SAP Datawarehouse

Problem I am trying to solve: (please scroll down for additional questions)I need to add campaign information to projects/requests without changing the existing flows.  This fix needs to update existing projects/requests as well as new requests/projects going forward.   Background:I have existing requests and projects in my portfolio and can't use programs to manage this.I have elaborate request forms and project templates.  All of which I have inherited.  I have users entering request who know which campaign(s) their request is being entered for.  My initial plan: (is this correct or is there a better way to proceed??)1. Create a new project template, add a multi select field (with a list of the campaigns), and bulk add this template to existing projects. 2. Bulk edit selected existing projects adding the new campaign selection(s).3. Add this new project template to the existing project template forms to allow future projects to u

Hi All, I'm running into issues creating a  calculated field that generates a name for either, Entered By ID or Primary Contact ID for requests converted to storyboards. For whatever reason I'm not able to pull that data over to a storyboard/tasks that is converted from the issue.  Does anyone know of a potential workaround?

I am preparing for my Adobe Real-Time CDP Business Practitioner Professional AD0-E602 exam. Could Could anyone provide detailed insights into their overall experience with the exam? Your experiences and suggestions would be incredibly valuable for me

Hi, I am trying to find an easier way to do this, my current solution works, but intermittently results in empty values. I am looking at the number of projects in each status and then pushing it back to Workfront for daily reporting. I am searching for a list of projects, then using a numeric aggregator module to get the number of projects in each status (this works perfectly). The aggregator module gives me an array of collections, with each collection containing Status and the count. Then I use an Arrar Aggregator module to combine all the statuses and counts into a single array. Finally, a Set Multiple Variables module will be used to set the count of each status to a matching variable that can be used in the workfornt update call. The Set Multiple Variable is where empty values are recorded intermittently.   

HI!I am have a task report that I need to group by the Business Unit, and then by the project Program. I was able to group by the project Business Unit without issue, but I can't pull in the project Program name with native functionality. I tried using text mode to achieve this (see below), but it returns the Program Name as "no value". Hoping someone can help me figure this out.group.0.linkedname=directgroup.0.namekey=MSD Business Unitgroup.0.valuefield=MSD Business Unitgroup.0.valueformat=customDataLabelsAsStringgroup.1.linkedname=programgroup.1.namekey=view.relatedcolumngroup.1.valuefield=program:namegroup.1.namekeyargkey.0=programgroup.1.namekeyargkey.1=namegroup.1.valueformat=stringtextmode=trueThanks!

Hi! I am running into an issue with text mode rules for a project report that references nested tasks.  listmethod=nested(tasks).lists Is it possible to apply a conditional formatting within this list method? Essentially, if there is no matching task I want the box to be greyed or have an icon. However when I apply the text mode coding that works in a traditional column, the text mode column shows the coding in plain text.

Hi! I have lines of business as queue topics on my request form. Is there any way that I can have display logic make a custom field appear if a certain line of business and or queue topic is selected?  Thank you in advance!JM