Adobe Workfront

Our team is a small Marketing team, and we have a need for an all-inclusive Content Calendar (screenshot below) that can show:Spans of campaign in-market time (not working on the project time, but actual in-market/after launch time)Individual Launch dates for items like social posts, email sends, blog posts, PR posts, etc.I've done my best to solve 50% of this (the individual launch dates) by using little emoji's in each "Launch" task in a Project Timeline, so that it auto-populates on our Calendar. However, I have not been able to figure out a way to automate the spans of the dates that a campaign is in-market. It's making me crazy. For now, I'm manually adding them, but I'd love to fix that.How are you doing this, if you are?? Or, even if you have something similar, bring it on! I'd love to see how others do this, and any ideas you have around naming convention, automating the tasks to the calendar, etc.  Any and all input/ideas are appreciated!!  

Hi Guys,seeking help here,I want to color the value using textmode, scenario: if Aging Days value is greater than SLA Value, color it red.how to insert a code to an existing code?here is the existing code in the "Aging Days" column.Thanks,   

I've added company days off to our default schedule, but there is nothing stopping users from assigning work to be done on days the company has off. For instance - we are closed tomorrow and Wednesday, but I am able to change planned completion dates to those dates without so much as a warning. Is this normal? Is there a way to show that the company is closed on these days when assigning out tasks? Any help/insight would be greatly appreciated!

Hi, I am a classic waterfall PM and Workfront Admin. About a year ago I started using the Workfront Kanban functionality to track and move forward some web governance work. Recently my company paid for me to attend some general scrum training, and I just received my PSM 1 certification.  I would love to connect with someone who is currently using scrum within their marketing department. I have some questions about how you define products; your cross-functional team make up and how Workfront plays a role in your documentation.

I'm trying to add either the name of the person who originally made a request, the field would be an Issue Primary Content or the Requested By, on a document report. Does anyone have insight on how to do this?

Anyone know how to report on the dates that a user volunteers to work on a task? Specifically, when a user clicks "Work on it" from the task window of a task that is assigned to a team. I'm trying to show how many tasks a user volunteers for each week.  In the system activity log, the post says "Christine Quick volunteered to work on this". But I can't find a "volunteered date" in the reporting options.  I tried Task > Handoff date, Assigned to > Date Issued, Task > Actual start date, but received no results.  Any help is appreciated!

Hi!! We're looking to pull custom field dates and checkboxes from the Project Custom forms, into a Custom TASK form to avoid the team looking back and forth. We've tried calculated fields, but they are showing "N/A" and all the solutions on Experience League seem outdated. Hoping someone is able to help or solve this!!

Workfront Planning Users - I need help! I have created a record type in Planning, and also created a request form for it. The required (not removeable) "Subject" field in the form, does not show up in the record when someone submits a new request. How do I get it to show up?It's odd to me that there is a Name field that can't be removed from the record or mapped to the subject field, which also can't be removed from the request form, but also is not visible in the record. Anyone figured this out? Thanks!!

Custom forms in Workfront aren’t just for collecting info, they’re your secret weapon for smarter workflows, better data, and smoother collaboration. And we know some of you are doing wildly creative things with them.    So let’s hear it: What’s the most brilliant, unexpected, or just plain cool custom form you’ve built (or seen)?  🦁   💬 Share: What problem were you solving? What made the form unique? Any tips, tricks, or lessons learned? Bonus points for screenshots (blur sensitive info!) or a quick walkthrough. We want to see the magic in action! 🪄

Does anyone know if there is a report that can be created showing any duplicate users in the system.   When we initially implemented Workfront, we used email addresses as their Federated ID's.  When we moved over to the Adobe Console, we had to change the federated IDs to match what we had in AD.  This created duplicate users in the system, and I would like to run a report listing those users.    Any advice would be appreciated.   Thank you.

Hi - Our organization has restructured, and our historical Groups were set-up by multiple teams, which has led to Groups being disorganized or redundant. We'd like to reorganize our Groups, but it doesn't look like there is a way to move current groups to become children of other groups. Is there, or could, there be a way to reshuffle groups without having to start from scratch? Some of our scenarios use groups for sharing so it would be unfortunate to have to start from scratch. 

I need to re-create a very detailed project status report in Workfront. Currently the status report is in an excel document. I'd like to upload all the status report information (columns and rows) into Workfront, so the entire team can go to one place to view and update it. Having the status report outside of Workfront makes our team look in two different places for statuses.  The project owner will manually update the status report several times a week. The fields within Workfront need to be editable.  I'd like to be able to import the excel spreadsheet into Workfront without having to manually create it. Basically, I need Workfront to act like an excel spreadsheet. How do I do this?

Hello All,Hoping someone can assist, I need to combine 5 fields into one column on a report but I need the outputs to display on separate rows.These are the fields names:ccoInclusionName1ccoInclusionName2ccoInclusionName3ccoInclusionName4ccoInclusionName5I have made a start but struggling to add the other fields and I can't find the correct syntax for the separate row break.If someone can assist me with completing this, it would be a big help.column.17.displayname=Inclusion Namecolumn.17.linkedname=directcolumn.17.namekey=ccoInclusionName1column.17.querysort=DE:ccoInclusionName1column.17.sharecol=truecolumn.17.textmode=truecolumn.17.valuefield=ccoInclusionName1column.17.valueformat=customDataLabelsAsStringcolumn.18.linkedname=directcolumn.18.namekey=ccoInclusionName2column.18.querysort=DE:ccoInclusionName2column.18.textmode=truecolumn.18.valuefield=ccoInclusionName2column.18.valueformat=customDataLabelsAsStringMany thanks,

I have a couple multi-select fields that I need to create reports for. I found this documentation- https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/custom-view-samples/chart-report-by-multi-select-custom-field which notes that "Rather than building a chart using a multi-select custom field, we recommend that you create separate fields for each option of a multi-select custom field." This may be a good option for the reporting that I need, but I'm not sure how this set up for a multi-select field would look in the request form. The only thing I came up with was to have the multi select field as a separate custom form section and the multi-select field selections show in the custom form section, example shown below:This would not be very user intuitive in the custom form, so I'm wondering if anyone has any other ideas on this multi-select field options set up as separate custom fields. Thanks . 

Hi,I am trying to build a workfront report that Pulls in List of Projects that are in Planning Status and None of the underlying Task is started yet, i.e all Tasks on such Project should be in New Status. Appreciate the help

I've got a project report that I want to include when the next Partner Proof is. I can get it to work using the specific task name like "Partner Proof 1" using the code below. Is there a way to code it so it pulls in any task that includes "Partner Proof" as part of the name (so, Partner Proof 1, Partner Proof 2, etc.)?  displayname=Partner Proof 1 listdelimiter=<p> listmethod=nested(tasks).lists shortview=true type=iterate valueexpression=IFIN({name},"Partner Proof 1",{plannedCompletionDate},"") valueformat=HTML

Has anyone found a good way to report on Project Template Updates? Since there is no update stream, not sure if it is possible to see when a field or assignment has been updated on a template task? My next step is seeing if Data Connect can offer any insight, but wanted to check in Workfront reporting offered any solutions. Thanks! 

Hi Team, We've been working on fetching data from a report via the Workfront API, but have encountered some challenges. Here's a breakdown of the situation: API Endpoint 1:Endpoint:   https://domain.my.workfront.com/attask/api/v15.0/report/search?ID=65d8d1ac001xxxxxxxxxxxx&fields=*,definition​   Response:  { "data": { "ID": "65d8d1ac001", "name": "Tracking ID 2024", "objCode": "PTLSEC", ::::: "customerID": "57212cda00a5431b1234567", "defaultTab": "C", "description": "This report shows a summary of all the Tracking IDs requests and their respective CIDs", "filterID": "65d8d1ac00122967d6705b3c457c3947", "uiObjCode": "OPTASK", "viewID": "65d8d1ac0012296543a71986de77c04d" ::::: } }   Issue: The data retrieved from this endpoint only provides metadata about the report, rather than the actual data it contains. API Endpoint 2:Endpoint:  https://domain.my.workfront.com/attask/api/v15.0/issue/search?customerID=5

Hi Community, Can anybody share a good adoption report for users besides the login update, which is just a snapshot in time, but more something that increased or decreased over time?I used the Workfront Usage Blueprint, but this one is also just a snapshot and not really a good evaluation of the current user adoption compared to e.g. last year.Thank you in advance!

I have a Report that some users are working from with a number of free text fields. Some of these fields contain long free text lists where other rows remain closely spaced. Is there some coding we can use to have the individual rows/fields become scrollable/collapsible?