Adobe Workfront

👋 Hello to all my fellow Workfront User Group (WUG) members from Southern California who are attending Adobe Summit next week! Let's meet up and say hello at the Adobe Booth in the Community Pavilion on Tuesday, March 18th at 11:30 AM PST (right after the main keynote). Head to the Community and Support section (back right corner of the booth in Peer to Peer Connection area). You can grab some swag, see a demo, and network with other WUG members from SoCal. Looking forward to seeing you there! 🚀RSVP here: https://adobe.ly/3R5exKI

It seems multiple notification options have been removed from the "Workfront Profile > Edit Person > Notifications" area.  There used to be a couple dozen, and now there are just three.  We've noticed this over the past couple of days, and are no longer getting certain notifications (such as predecessor task completed) that we rely on for our workflow.Have these been deleted, or perhaps moved to a different location in the settings interface?

I've entered the following expression in a calculated field to remove pieces of text/numbers from another custom text field, but I get the following error message: "This is an invalid custom expression, please try again." LEFT({DE:Custom Field Placeholder}, 7), & MID({DE:Custom Field Placeholder}, 9, LEN({DE:Custom Field Placeholder}) -8) Am I missing anything in particular?  Thought I entered it correctly.

Hello,we have Automatic Reminders turned on in Workfront but I am trying to understand which date it is using to constitute something as overdue.Example: A task was entered on 2/27/2024 and a due date was set for 4/9/2024. The due date later was changed to 6/1/2024 and then again to 8/1/2024.The automatic reminder seems to only look at the first due date (4/9/2024) and does not take into consideration the due dates that were updated later.Has anyone else found this to be happening?If so, this is a bit frustrating since I know the due date has not yet passed but the automatic reminder makes it seem like it is way overdue. Shouldn't it look at the current due date to determine if a task is overdue? Any help or insight is appreciated.

I am working with a coworker to create a report that will show the cost of each license type that users have tied to their account. What we are trying to do is show the license associated with a user and the cost of that license in a column. The problem is that a custom calculation field isn't showing the cost of any licenses, and as a result, there is nothing to show in a report. Is there a way that we can do this, or is it something that we would need to incorporate something like Fusion into? Below is a screenshot of what we are using to call a field that should be providing license cost data, but is not. Is there something in that code that is incorrect or being called in the wrong way? Thank you!

Hello. I am looking for pointers on the best method to do this. I've never actually been asked by users for this and I know there have been some changes in what possible.If I have a team that wants to see the diffference between the planned and actual hours in a column, my first assumption is that this would be done using a calculated field. Does this field need to be applied to a custom form for each task? Or is there a method to create a column in a view and do some text mode magic.  I did a search and I know there's alot out there about this but some of it goes waaay back. I'd like to hear from you what's best with current options. thank you

Hello Workfront Community,I am currently working with the Workfront API and trying to filter records using the lastUpdateDate parameter. However, I am encountering an error when attempting to query for records using this field.I am trying to use the following query to fetch project-level records based on the lastUpdateDate field:https://yourdomain.my.workfront.com/attask/api/v19.0/proj/search?fields=*&lastUpdateDate=2023-05-24T23:46:03ZInvalid Parameter: lastUpdateDate value "2023-05-24T23:46:03Z"My question is:Can we use lastUpdateDate to filter records at the Project, User, Issue, and Task levels?If yes, could you please help me understand how to properly format the lastUpdateDate parameter for filtering records at these levels?Is there any specific syntax or rules I need to follow for the lastUpdateDate field across different entity types (e.g., project, task, user, issue)?Any assistance or examples would be greatly appreciated. Looking forward to your guidance!Thanks!Ujjwal Kum

Does anyone use Workfront to track a room or piece of equipment as a resource? For example, our AV Media team may need a specific type of equipment for a project and want to see if it is available. Is anyone using Workfront to track resources other than people? Cindy Mersch TriHealth, Inc. cindy_mersch@trihealth.com

I have a document report set up to list documents. It is filtered to show documents within a specific folder (text mode from this post: Document Report to Identify Number of Files in a Specific Folder) and project status is set to planning and current : folders:name=final folders:name_Mod=cicontains project:status=CPL CUR project:status_Mod=inWhich works, but it shows ALL documents in ALL projects.I need an extra filter to show owner home team. In another document report, I have project status set to planning and current and also filtered by owner home team:owner:homeTeamID=abc123 owner:homeTeamID_Mod=in project:status=CPL CUR project:status_Mod=inThis also works but doesn't show me the file I want in the specific folder, as per first example. When I put the text mode together, i.e.:owner:homeTeamID=abc123owner:homeTeamID_Mod=inproject:status=CPL CURproject:status_Mod=infolders:name=finalfolders:name_Mod=cicontains I get nothing showing up. Where am I

Hi, I'm working on moving some documents from Adobe Workfront to AEM assets using fusion. I'm using Upload an Asset module in my scenario to upload the document to AEM asset and came across the below fields. Does anyone know what are they used for? Create versionReplace Currently when I upload same document again, it overwrites the previously uploaded document. Is there any way I can keep both the versions of the documents? Thanks! 

Hello Community.  I have started to think about switching over our current custom Fields we have that list team member (just values).  that we have to manually manage everytime a user leaves etc.   To using the External Lookup to dynamically display the Team Members.  This way, the Manager of the Team can more easily manage the Team and the list,  And then in my custom forms the list is always up to date.  However, I can't seem to figure it out. I honestly don't know what I am doing here.   I have been able to write a API URL that will pull a top level item like Portfolio names but I can't seem to get more than that. I keep getting errors in my Projects.  Does anyone have an example API URL that they are pulling Team member from a particular Team name?My current attempt is: $$HOST/attask/api/v18.0/PORT/search?ID={62bc509f0078fa8703af0eda89d16e7d}&fields= teammemberswith the JSON Path being: $.data[*]. teammembers

Hello, I am trying to configure a textmode column to display who is filling certain roles on a project. I have this textmode to get it working on a project report but I am unsure how to tweak it for an assignment report. Here is my code:description=Team Users displayname=Creative Roles On Project link.linkproperty.0.name=ID link.linkproperty.0.valuefield=userID link.linkproperty.0.valueformat=int listdelimiter=<br> listmethod=nested(projectUsers).lists name=ID namekey=assignment.plural stretch=70 type=iterate valueexpression=IF({user}.{roleID}="53beed9c004ebf57e7a83caffa893a89" || {user}.{roleID}="58d97b9e004ada7cbf3e81ba6c649a48" || {user}.{roleID}="5d84f13e0063dd16b96fcb0c42f714df" || {user}.{roleID}="5458cd0300113c8b8b5f50f821bc6ddf" || {user}.{roleID}="5ab11c1200734f7fa047c04f062afe57" || {user}.{roleID}="53beee46004f251d355dc780bb32a84a" || {user}.{roleID}="5f6c9d7800186cbf89cec913fc61533f" || {user}.{roleID}="64beb1880006e8ec3ffc3d8e2d3f7834",CONCAT({user}.{name}," - "

Is there a way, maybe with share settings, to prevent users from adding any more documents. after a request is converted to a project.The only way I see is to remove all permission from all users except admins. Thanks in advance.

Hello, and thanks for any support in advance!  I am trying to run a project level report which would show all projects that DID NOT have a type of request submitted as an intra-project request.  Overall example: We expect one of our teams to submit two intra projects requests; one at the start of a project and one at the end the "rank" the project. I am trying to think of a way without Fusion to flag when these HAVE NOT been submitted. Like a governing check to confirm who did not follow process.  Thanks! 

Hello all, I think this will be a fairly simple text mode question for some experts in text mode.  I need to create one report to show a consolidate parent task list from several projects. I've tried creating it in task report and a project report, and I just can't get to the list I want.  Any help will be most appreciated.  Peggy 

Hi All, running into an error when trying to upload a field from a csv file into a form field has dropdown options.  The field on the csv is identical to the option in the form. [422] Invalid Parameter: custom workfront field "custom dropdown field value"

What happened to "Irrelevant" in proofing? This is an important decision choice to inform people in the process not to waste time on that version.

Hello Folks,I have a question regarding the steps needed to perform the adding of a new FUSION Connection but have it associated with a 'system level' user from our  WORKFRONT 'SANDBOX 01' instance...not associated with the actual System Admin person's account who actually created the connection.We 'can' (of course) create a new FUSION Connection ,however, unfortunately the new 'Connection' is associated with the member's account from my company's Workfront nd fusion Support team.  We have a fake 'system level' user which we've named 'Workfront Fusion Admin' which is defined in WORKFRONT, however, this fake 'system level' user named 'Workfront Fusion Admin' is not an actual TEAM member within FUSION nor is a USER defined for our FUSDION app defined within the Adobe Admin Console.Thoughts ?Thanks,    -Scott Davis- Tech Lead, The Vanguard Group       

Has anyone had success using the External Lookup field to limit custom dropdown field options based on the response to a preceding custom drop-down field in the form? Example:We have Business Units, Product Lines, and Products. I want to limit the Product Lines to only show the options that fall under the business unit they have selected. Then, I want to limit the products to only show the products in the product line they have selected. I understand External Lookup is supposed to make this possible, but I'm having a hard time figuring out how to set this up. Does anyone have an example they'd be willing to share? Thank you!

Hello! I am having trouble with a DATEDIFF calculated column on a task report. One column is a calculated date field on a custom form field on the task level (Go Live Date Task Level) and the other is the actual completion date of the task (Actual Completion Date). When editing in text mode, none of my attempts produce a successful result. All results are blank, is what I am trying to accomplish possible? 

My team and I are trying to figure out a way to create a .doc/.docx document in Fusion and upload to Workfront, which then will be converted to a proof.  Here is how we are "trying" to upload the document as a .doc/.docx format using the Upload Document Workfront Module: However, when we create the document using this method, the file is un-openable in Word (seems to be corrupted) and is failing to generate as a proof when using the "Create Proof" option in Workfront. Does anyone know if this is the correct way to create a word document using the Document Upload module? We are aware of the Microsoft Word Template modules but are trying to avoid having to use this as it requires a Word license. Any information on how we could get this issue solved would be greatly appreciated. CC: @jyotina