Workfront

Hello All, I am trying to complete a formula where a calculation will only CONCAT fields if there is data to CONCAT. CONCAT(IF(custom field called Role 1 has data,CONCAT(Role 1 GL Code," | ",)," ", IF(custom field called Role 2 has data,CONCAT(Role 2 GL Code," | ",)," ", IF(custom field called Role ...

hi folks, I'm trying to make a project report grouped by owner's home group name. I only have the home group ID field available in grouping, so I textmoded it to make it name instead of ID. It worked fine in the details tab but is No Value in the summary and chart tabs. Is that normal? (does it just...

Hey folks, I've been trying to get field comparisons to work and so far they don't. What am I doing wrong? :) Here's one where I'm comparing the task planned completion date to the default baseline task planned completion date. If the two are not equal, make the text red. The textmode for the column...

Hi All The"https://support.workfront.com/hc/en-us/articles/115000135574-Event-Subscription-API" Event Subscription API Documentation in the "https://support.workfront.com/hc/en-us/articles/115000135574-Event-Subscription-API#forming-the-subscription-resource" Forming the Subscription Resource sectio...

Hi all. I can get my multiple column sorts to work fine in my associated report, but I can't seem to get them to sort properly in my initial view. I am trying to sort by three different columns. All three show the little sort icon when I'm in edit mode, but only the first sorted column actually seem...

I have a simple calculation (below) to display a project or request end date. The issue is whenever the date is changed the calculated field is not recalculating. It stays the value that it was unless I go update the form or click "Update previous calculations" on the form. Is there a way to force a...

I'm currently stuck with a problem when it comes to nested statements. I'll try to explain what I'm trying to do. Choice 1 Choice 2 Choice 3 I have 3 choices that my calculation is looking at. Each only one choice will have data and my calculated field will display that data. This is the ...

Hello All! TLDR: Follow the GitHub link to see my Integration. I am admittedly pretty new to using Workfront's API, but I think I've put together something pretty useful for a non-native integration between Outlook Calendar and Workfront Time-Off Calendars. I spent a couple of months designing/devel...

@Alison Milbury , Would it be possible to set up a discussion group/thread/section for just text mode examples? There is so much valuable examples scattered through out the community site but it doesn't seem like there is a central place where we can store them, catalog them, tag them with different...

Hello~ Anyone know how I can create a report that shows what custom forms are attached to what projects? Thank you, Susan Susan