Workfront

Hello, Does anyone know how to "ignore" a blank field in a custom field average calculation? Example: AVERAGE(Comp1,Comp2,Comp3) Comp1 =30 Comp2=30 Comp3 is blank Average = 20 (should be 30) Thanks! Patricia Greene JLL

Looking for best practices/methods for dealing with these two scenarios: How do you hold onto deprecate fields that you still need around for reporting without cluttering-up custom forms? In other words, I understand I can't remove a deprecated field because it would vanish from older jobs and los...

This one has me stumped for today and hoping someone can let me know what I am possibly overlooking or not thinking of. Here is the situation: A user submits a request through a request queue. The request is routed to an Agile Team (Scrum). The team manager vets the request, and then converts the r...

We attach routings via Workfront Proof to a specific task to aid tracking (i.e. the document being routed/reviewed is uploaded to the task), and we had an interesting request today: Can you apply a conditional style based on whether a a WF Proof-routed document is attached? Say for example, in the p...

I'm trying to figure out how to configure our proofs so that the proof owner isn't getting so many emails. We have the designer upload the proof and send it through an automated proof cycle. Originally we were having the designer use the setting of "all Activity" so they were notified of everything ...

I'm trying to capture date and time in a calculated custom form, as it describes here: https://experience.workfront.com/s/article/Understanding-Common-Uses-of-Text-Mode-37391990#calculated-custom-fields Was able to copy the example in that Help section almost exactly. I'm trying to get the date/time...

Hi, Can someone please help out with the Project Form? I have added all the info from the Request Form to the Project Form but it is not showing up on the form when someone submits a request? Not sure what I'm doing wrong. thanks Jennifer Jennifer Miklasz Fidelity International

Hello, Is there a way to create a custom field on a custom form that will list all active projects? Preferably a type ahead, or a drop down. Curtis Gifford Kronos

I'm trying to make a form/approval workflow that based off a dropdown box will choose which way the form approval goes. The form has a department dropdown box, which is called 'Cost Centre'. The approver needs to change based off which department is picked, not just the manager of the person. I can'...

is there a simple way to show duration in weeks as calendar weeks? If I put in 26w starting January 1st, I get Sept 20 as a finish date. I was expecting end of June. So obviously a week is calculated based on 7 work days not 5 work days. Other PM programs (like MS Project) show weeks as calendar wee...