Workfront

Hi all,I am using the below endpoint to get access token for authentication.https://yourdomain.my.workfront.com/integrations/oauth2/api/v1/jwt/exchange The body of the request has Client ID, Client Secret, and JWT (generated by pythonic code, signed with private key):client_id={client_id_value}&clie...

We would like to create simple hours reports at each of three different levels (Portfolio, Program, and Project) that simply show total hours in one line item per user (does not expand to show each individual task).  Currently when these reports are created, there is a summary but there are also lin...

I'm setting up automatic project numbering using the last four digits of the reference number. This is the formula I'm using:CONCAT("G24_" + TRIM(RIGHT("0000" + STRING({referenceNumber}), 4))) This works except for one problem, It pulls in the last four characters, of which one is the separating com...

What could be the potential causes and solutions for a ConnectionError [500] com.fasterxml.jackson.databind.JsonMappingException that occurs during a fusion flow in the search record module, and is there a way to prevent this connection error from happening again in the future?ConnectionError[500] c...

Hi I'm trying to create a custom column in an issue report where the name of the issue only appears if the issue sits in a particular project, does anyone have any ideas on the code needed? Thanks Chris

Hey all,What are the possible solutions to fix an issue with Workfront and SharePoint integration where clicking "trust it" starts a spinning loop that never resolves?

I’m working in an Hour report and have two calculated columns, one for “Billable Hours” as followsaggregator.displayformat=doubleAsDoubleaggregator.function=SUMaggregator.namekey=hour.pluralaggregator.valueexpression=IF({hourType}.{countAsRevenue}=true,{hours},"")aggregator.valueformat=doubleAsDoubl...

So in workfront when things are deleted they live in the trash for 30 days and then are automatically deleted.Does anyone know if proof works the same way? I can see there are a lot of files in my organizations proof trash bin and wanted to know if these are from a specific time period(like the last...

Curious how other companies take into account what resources already have committed to for meetings when assigning time.  We only assign 6 hours of project work, but there are days when resources already have 4 hours worth of meetings within Outlook and we don't have visibility to that. 

I have a deliverables spreadsheet for my creatives that split across multiple tabs in Excel (one tab for the social assets, one for the CRM assets etc...). Anyone know if it's possible to split each tab of that Excel into a CSV using Fusion so I can ingest it into Workfront?