Workfront

Hi Everyone, I am currently using this expression to calculate the # of days between two dates: DATEDIFF(Entry Day,Actual Completion Date) I'd like it to ONLY count week days. Is there any way to filter out the weekend? Note: Entry Day is a custom date field: IF(ISBLANK(Entry Day),"",Entry D...

Hello ~ I have a report that shows Users and licenses allocated (Plan/Work). However, not all the licenses are being used. For instance, I have 47 work licenses but only 36 are currently allocated. Is there a text or code to show the remaining 'open' licenses? Thank you

Is there a way to give a user access to the sandbox/preview environment without being an admin? We have a developer interested in learning more about WF and is interested in working in the sandbox, but she is not an admin, and we want to keep our admins to a minimum.

I've had a lot of interest lately from other customers about using Workfront to manage events. If you are using Workfront to manage tradeshows, conferences or other events, please tell us a bit about how you use it and how it's working for you. Thanks!

We've been using the reference number for a project as an identifying job number since our implementation. This was working OK--but after only 6 months in, the number is already 6 digits long, so we're on the hunt for another solution. Does anyone have any recommendations on how you populate job n...

Hi, This morning I noticed a big LEAP advertisement sitting on the right-hand side of our Workfront login page. Not only does it look plain ugly sitting next to our normally nice but now-squished login screen, it is irrelevant to 99.9% of our users' roles. It is even more irrelevant given that mos...

Hello, I am looking to create a project-level report that displays the status of multiple tasks within each project. I want it to look like this: Project Name - Task 1 - Task 2 - Task 3 (Columns) Project 1 - Complete - Complete - In Progress Project 2 - Complete - In Progress - In Progress ...

I want to report on the changes to Project Planned Completion Date. Unfortunately changing that date, and most fields is recorded as a journal entry and doesn't create a note visible in the notes field. The journal entry object is now exposed to the API, and I know this was some discussion of ...

Hello all, I have several projects with tasks that require cross-project predecessors and I want to create visibility on how many tasks are broken per project. I need a report that shows all tasks containing 'Link to' in the name that do not yet have their predecessor. Can anyone help? I'm stu...

Hi all, Which option are you using for 'Calculate Percent Complete based on': Planned Hours or Duration ? And how actually Duration got influence on Percent Complete? Does it mean if you assign someone to a task which we're giving them e.g. 5 hours to do it within 5 days, it would be 100% comple...