Adobe Workfront

I've been asked to show a date in a report asSat, 3/8/25However, from what I see I can only showSat, Mar 8, 2025 or 3/8/25 (without the day)To workaround that limitation, I want to only show the first 5 characters from the partialAtDate - so "Sat, "Then I'll use sharecol to show the date ( format atDate) after that, so 3/8/25The text mode I'm using to only display the first five characters from the left is below, but the report isn't showing anything in the column. Can someone tell me what I'm overlooking, please?linkedname=direct namekey=plannedCompletionDate querysort=plannedCompletionDate valueexpression=LEFT({plannedCompletionDate},5) valueformat=partialAtDateIf there a better way to get to my desired result, I'm all ears!Thank you.

Hi Workfront Community,I'm currently facing an issue with filtering for the current iteration in Workfront reporting. Despite selecting the iteration status, it doesn't seem to return any results.Has anyone else encountered this problem? Is this a known issue or a broken feature in Workfront that prevents setting the current iteration in reports?Any insights or workarounds would be greatly appreciated! Thanks in advance for your help! 

Hi all, I'm trying to use text mode in a report to gather all the project users in a column, based on their company ID and their home teams.I have been using the expression below to gather users based on company ID only, can you help me with also adding home team as criteria?displayname=xyz listdelimiter=<br> listmethod=nested(projectUsers).lists type=iterate valueexpression=IF(IN({user}.{companyID},"123"),CONCAT({user}.{name}),"") valueformat=HTMLThank you! 

Hi all - I want to know if there is a way to pull task info into a Project report? For instance, if I need a column on a Project report to show the Due Date of a specific Task, if there a way to pull that into a column? Thanks!

Please join the Stensul and Adobe teams for an exclusive networking event to connect with industry leaders, explore powerful integrations, and enjoy a night of great vibes! RSVP here!Details: Date: Tuesday, March 18Time: 7:00 PM - 9:00 PM PT. Before the party starts, swing by the Adobe booth in the Community Pavilion for an exclusive demo from 6:00 - 7:00 PM PT. Location: The Oak Room Whiskey & Tequila bar is in The Rockhouse, just a short walk from the expo hall. The Rockhouse is on the second floor of the Grand Canal Shoppes in The Venetian Resort.Don't forget to RSVP! As an official Adobe partner, Stensul integrates seamlessly with Workfront, Adobe Journey Optimizer, Adobe GenStudio for Performance Marketing, Marketo, Campaign, Adobe Experience Manager and more. Can't make Tuesday night? Stensul is hosting other events, dinners, and activations throughout the week! Check out the full lineup here! 

Hello, I am building a scenario that when a project is made active it will post an update on said project of the project's Milestone schedule. So far my trigger works fine and I can pull a collection of tasks, filtering down for only Milestones. Where I am caught is how to take those bundles of Milestones and format it (in a variable?) such that it sorts the planned completion dates of all the Milestones. Any guidance would be greatly appreciated, thank you!

I'm one of the new (still learning) system admins for our Workfront instance.  We are trying to create an external lookup field that will find all of our projects that are in the "In-Progress" (CUR) or "Planning" (PLN) status.  I am having a hard time determining if Workfront supports syntax for "OR" not to mention what it would be.  We have tried using ||, however that didn't seem to produce the results we wanted.This is what we have so far: $$HOST/attask/api/v19.0/projects/search?status=PLN||status=CURWe have also tried: $$HOST/attask/api/v19.0/projects/search?status=PLN,CUR  $$HOST/attask/api/v19.0/projects/search?status=PLN&status=CURplus some other variations. Any advice would be appreciated.

I am working on a project to remove three tasks based on a selection option on the project. if the selection is "What type of template change is this?" = "Minor" then three tasks are to be removed from the project. So when the user creates this project and selects that choice then fusion removes three tasks from the project. "Reg review, Legal Review, Peer Review". I started with a search module looking for projects created with a specific template, then used a read module to gather the data, then i need to point to the choice on the project. i'm thinking i may need a switch module for the choice. Any help would be appreciated.

I've created a report filtering for two parent tasks within one project: Plan Campaign and Execute Campaign. I want the report to show the number of weekdays that transpired between the actual start date of the Plan Completion parent task and the actual completion date of the Execute Campaign task. Any tips? Thank you in advance!

I have a fusion scenario that builds a project "recertified" with tasks based on a template. if a user selects a certain Status "decommission" Fusion goes in and removes the tasks from the project and adds a new template with different "decom" tasks. Now, if the user didn't mean to choose that status or perhaps down the line, this project didnt need to be decom'd, can fusion be setup to undo, or re-add those old tasks back in and remove the decom tasks. Basically re-setting the project back to its original "recertified" state again? would this take a large level of work to build this scenario or would it be better to tell the users to be careful in their choice?

I am playing with the JWT module and with help from support got it to where I can exchange it for a bearer token. According to documentation, to authenticate on the API I'd send it as "Authorization" header - but so far the API just errors out with an authentication failure.  Have you successfully called the Workfront API with a bearer token? 

Is it possible to create an email template and attach it to a Proofing workflow? So every time we send a proof, the email is standardized? Right now we have our standardized language in a Word document and copy and paste into the email in the Proofing workflow, but we would love it if the language could live inside Workfront.

Stay with me... I'm part of a creative services team and we have 1 custom form for our requestors to fill out. This form has options of a print request, promo request, digital/paid media request, language translation as well as other options of types of work needed. Requestors are able to select multiple choices, perhaps print and digital together. With each choice the specific set of questions or section populates on the form for requestors to answer related to that specific request type. When multiple ones are chosen, you could have 2, 3 or more separate sections on the form that have been filled out. My designers are finding that it is very hard to sift through each section, reading the answers to the questions, checking the boxes they've selected for types of assets (flyer, brochure, ad, billboard....), sizes and instruction boxes and at the end knowing exactly what they need to do - how many print items, how many digital items? Sometimes we can end up with upwards of 30+ assets/fi

I'm trying to understand why a watch record module for documents that I have set to look for new records only, is returning old documents from February.  What criteria does it use?  Do I need to perform an additional date test? Thanks in advance!! 

I have a project template with proofreading as a task. I have created a custom form and attached it to my projects so our designers can communicate to our proofreading team and provide them the specifics on what needs to be proofread and where it’s located.Once the designers have completed the proofreading form, is there a way to automatically notify the proofreaders that the job is ready for them? Here are the only two scenarios I have come up with so far: The designers @ the proofreading team in the Updates section of the project, letting them know their job is ready to be reviewedI add a checkbox to the custom form that would trigger a fusion scenario to notify the team. The caveat there is that every job requires two proofreads, so I would then have to create two checkboxes, no? Is there something glaring obvious that I am not thinking about here?

Hi there, Is there a way or a workaround to duplicate a program that contains the same projects that are updated on a quarterly timeline?

Hi, We have a requirement where we need to keep adding option in dropdown based on meta data we receive everyday. SO that user can select values through dropdown.Can we have some Workfront API through which we can do so or any fusion module can keep on adding option dynamically into Dropdown. Any help or suggestion is highly appreciated. Thanks

Hi, When I am trying to create a watch event scenario (for instant trigger) for a new issue to be created in a specific project (via request queue), It kept on running and end up giving error that "maximum time limit exceeds". Seems like its unable to read that data. Can anyone help me with that? Also, Was wondering if watch event support for new Issue in Workfront fusion? Any help/suggestion would be highly appreciated. TIA. 

How to get below highlighted date from the iterator bundle output?  

My WF instance has two separate companies. I am creating groups and noticed that there are job roles already in the setup for my company that I had not created. If I delete these job roles, will it effect the entire workfront instance or only delete the job roles at the company-level? We don't have any tasks assigned to job roles in my company/groups.