Workfront

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? 

Hi, I have our agency uploading packaging proofs to ProofHQ. Once we make decisions such as "changes required", our agency usually uploads a new version and it comes through as the next version and we no longer see the "changes required" proof in our dashboard. I noticed on a recent proof the agency...

The scenario: We produce marketing pitch books on a monthly basis. Sometimes the date changes, so the month-end date has to change in the custom form. For example: 30-Sep-23 gets changes to 31-October-23 if the meeting gets pushed back. I am having the hardest time finding any projects that referenc...