Community Topics

Hi all, I'm trying to run a report with the number of unique proofs approved that were authored by a creative team. So far I'm seeing multiple approvals of the same proof, and I'd like to eliminate multiple approvers and versions of the same proof document. The filters I'm currently using are for th...

I'm trying to create a report that shows how many projects have a task planned date that is past due by project manager.So I either need to use the task-level report I already have and create a chart by unique value of project name, OR I need to create a project-level report that draws on task plann...

How can I get the Project Manager name to populate on a task-level report? It's not a specific task or project field but I can get it to populate on project reports and not on task reports. I've even tried this formula which has worked on project-level reports but hasn't worked on task-level reports...

I have a Proof Approval report set up, and it has columns that show key information like Approver Decision, and the Decision Date, but I'm wondering if there's a way to pull in something like proof has notes/comments, comments exist = true/false, etc. Reason being is that we often have reviewer/appr...

I have several reports in the system pulling Issues with a column for resolving object. The resolving object column is appearing blank even though in the Workfront report there is a link to the Project name.Does anyone know how to get around this? 

How can you access Proof ID in the document report to add it into prompts

I have field with dropdown options and i want to see grouping based on that field. 

Hi All,  I wanted to know if anyone has created a Fusion scenario to generate a $$USER.ID report displaying all of the active proofs a user is listed as just a 'reviewer' on a report.  This is something I've been meaning to tackle for a long time.  I imagine others would benefit from this to.

I have tried for a few days and cannot figure this out.  I tried via a project, task and custom form report unsuccessful.  I entered a support ticket and was told to use a custom form report but can't figure it out and waiting for support. Anybody willing to share text mode from custom form report t...

Hi all, I can pull the field actualHoursLastMonth into my project report, but can't seem to filter on it. Is it possible? ThanksMatt

I'd like to have a user's phone number format as (xxx) xxx-xxxx in a report.I tried the suggested text mode below, but it returns only 7 out of 10 numbers. it's missing the middle three numbers.valueformat=HTMLtextmode=truevaluefield=phoneNumbervalueexpression=IF(ISBLANK({phoneNumber}),"",CONCAT("("...

Has anyone been able to access Canvas dashboards from Sandbox? Would love to test it before going to prod.