Adobe Workfront

First and foremost, a huge thank you to Matt Mitchell @mattmi3 from the Product team for sharing his expertise around what Data Connect is and how it can be used to access Workfront data and provide visibility to drive business decisions! If you weren't able to attend today's workshop - we've got you covered. A short summary and resources from the session (slide deck and recording) are published below: Slide deck PDFWorkshop recording   Summary and resources from the chat: What is Data Connect? A secure and scalable solution that provides business insights by connecting Workfront data to visualization tools like Tableau, Power BI, Domo, and Looker. It is included in the Ultimate package, but available as an add-on ($) for those on Prime and Select. Reach out to your Account team for more information. While we aren’t able to provide you with a test drive (at least right now) to play around, you can always reach out to your Account team to see if they can he

Hi everyone,I'm trying to retrieve all teams from a Workfront domain using the following API endpoint: https://origin-acnmktgcomms.my.workfront.com/attask/api/v15.0/team/search?apiKey=xyzHowever, this only returns 100 teams. Is there a way to get all teams, not just the first 100?Do I need to use pagination or some other parameter to retrieve the full list?Any help would be appreciated!Thanks!

Does anyone have any report ideas to show people doing well in Workfront?  My director asked my manager for reports to show Marketers doing well.  All of our reports call out users not following the process, so I explained that if their name is not on the report, then they are following process.  But I guess he's looking for a report that highlights their name in a positive way.  Any suggestions would be helpful.

Hi All,I was wondering if I can use a wildcard in the Workfront email templates (Setup > Email > Email Templates) that renders as the full base URL of the Workfront instance. I.e. "<domain>.<instance>.workfront.com" (if not on Admin Console) or "experience.adobe.com/#/@<ref>/so:<domain>-<instancename>/workfront" (if on Admin Console).The best I was able to come up with is $$user:customer:domain$$, but I would still need to manually enter the <instance> (i.e. "my", "sb01", etc.), so the HTML code of the email template needs to be adjusted for each of our instances.Appreciate any ideas.Tibor

Hi All,We have a report that returns the users name for a specific role type in a project. The text looks like this:displayname=Copywriter listdelimiter=<br> listmethod=nested(projectUsers).lists type=iterate valueexpression=IF({user}.{role}.{name}="Copywriter",{user}.{name}) valueformat=HTMLThis works well if that role type exists in the project. If that role type does not exist in the project, the column is blank. I am trying to solve for this use case. If that role type doesn't exist, pull in the username from another specified role type, "Copy Leadership".I've tried using nested IFs, ORs, and EXISTS but can't seem to figure it out. I am newer to this side of WF, any tips help!

I am trying to create a project view that will display the selections made in two dropdown fields in the custom form. I have no problem with the first column, but the second column is a problem. I'm hoping this is something that can be solved with text mode, but my text mode knowledge is extremely limited. Here's the situation: We have Field 1 with nine possible choices. There is display logic for that field, so depending on which of the nine choices is selected, Field 2 (or 3, or 4, etc.) opens with it's own set of choices. I want to have a column for Field 1 (no problem there), but I would also like a column for the selection in Field 2 (or 3, or 4, etc.). I have spent several hours now searching through the community posts but haven't found anything that solves this particular problem.

Our marketing department structure was redone into 5 centers of excellence (COEs) about a year ago. Currently, only 1 of the COEs uses Workfront as their project management software. We are beginning a transition into all COEs having Workfront, as well as incorporating the Planning tool. I'm just curious if anyone has transitioned from one group using to several, with possible "groups" created to privatize certain projects specific to one COE. If so, what are the challenges you had and what can we think about when planning the license structure and user setup. 

Hello, I created a Journal Entry report and added Portfolio: Name as one of the fields, but for some reason the portfolio name does not appear in the field.Does anyone know why?

I have a report already filtered by specific project criteria and in a column of the report, I'd like to list the name of any documents in a specific folder within that project.I can get a list of names of documents using below code, but it doesn't seem to pull in document description or folderIDs which I could use to filter out ALL documents to just get the ones in a specific folder or with a specific description.Is there any way to just get a list of documents that meet other criteria (folder or description) to avoid getting ALL documents within a project ?displayname=LISTlistdelimiter=<br>listmethod=nested(documents).liststype=iteratevalueexpression={name}valueformat=HTML

I'm looking to setup two tasks -- one for "Meeting" and another for "Schedule Meeting".  I'd like the "Schedule Meeting" one to dynamically start 2 weeks prior to the "Meeting" task, which has other dependencies on the rest of the project.I've tried a number of different options related to both predecessors and constraints.  Anyone have any thoughts on how to do it?

Hi team,  We are currently piloting a Workfront Board with one of our marketing teams. Our goals are to 1) capture all requests that come to that particular team outside of normal process via a request form and 2) allow them to review and align a member of their team to the work/task using the board. We have created a Kanbon board for this pilot and requests have been populating in the intake column as intended, but the information collected via the custom form when the requests are submitted does not show when we click to view the card on the board. Is there a way to have the custom form fields show when viewing the card in boards without clicking the link to the log itself and navigating to a different page? Best,E

I want to know the list of Layout templates available in the system and its assignments to see if there are any Job roles assigned to them.Can someone please help me how to achieve in Text mode column? Thanks in advance!

Hi all! I'm working on a project report, and have added a column with the following text mode code:displayname=People listdelimiter=<div> listmethod=nested(projectUsers).lists type=iterate valueexpression=CONCAT("• ",{user}.{role}," — ",{user}.{name}) valueformat=HTMLI've used this basic setup in other reports too. It gives me something like• Design Operations — [user1]• Designer — [user2]• Copywriter — [user3]• Designer — [user4]etc etc I'd like it to instead give me• Design Operations — [user1]• Designer — [user2], [user4]• Copywriter — [user3] Bonus points if you tell me how to put {user}.{role} — in bold!

Hi, I've received a couple reports from my user base letting me know that they are unable to see any custom data on reports.  The data is visible to them on the custom form but when in a report they cannot see the values.  I'm an admin and can see the values but when I log in as them, I experience the same issue they were.  From my limited testing, it looks like this is only happening on TASK reports. Is anybody else experiencing this very odd issue?

I wanted to check the permissions of all my portfolios but there is no native field for such column. The one field which is giving me some data is - "Category - shared with". Is there anyone who has created such a report where one can see Portfolio name, Portfolio Manager, Group name and who all have access to the Portfolio (View/Manage)?

Hi Community,We have a request queue with a calculated field adding certain capacity points for certain requests:1. Creating New content for Sprint x has 2 points2. Updating existing content for Sprint x has 1 point3. Re-using existing content for Sprint x has 0 points.How do I set up a calculated field, that is adding up all the calculated fields from all incoming requests into one field to determine the capacity for sprint x?Thanks in advance