Workfront自定义筛选需求：查找缺失指定任务的项目计划

I’ve dealt with this exact issue in Workfront before—system default filters can’t directly detect missing specific tasks (they’re built for missing field values, not missing task records). But there are two reliable workarounds using custom reporting tools:

Option 1: Project Report with a Custom Calculated Field (Recommended for Ongoing Use) #

This method creates a reusable filter that automatically updates as tasks are added/removed from projects.

1. Create a new Project Report

   • Navigate to Reports > New Report > Project to start building from scratch, or edit an existing project report you use regularly.

2. Add a Calculated Column to Check for the Task

   • Switch to the Columns tab, click Add Column > Calculated.
   • Name the column something clear like Has Identify External Resources Task.
   • Paste this Workfront expression into the calculation box:

     IF(EXISTS(Tasks:Task Name="Identify External Resources"), "Yes", "No")
     

     What this does: The EXISTS() function scans all tasks under the project. If it finds any task with the exact name "Identify External Resources", it returns "Yes"; otherwise, "No".

3. Set Up the Filter to Isolate Missing Tasks

   • Go to the Filters tab, click Add Filter Rule.
   • Select your new calculated column (Has Identify External Resources Task), set the operator to Equals, and choose No as the value.

4. Save and Run the Report

   • Save the report with a descriptive name (e.g., "Projects Missing External Resource Identification Task"). Now you can run it anytime to get an up-to-date list of projects missing that specific task.

Option 2: Reverse Filter with Task + Project Reports (Quick Temporary Fix) #

If you need a one-off list and don’t want to build a calculated field, use this two-step method:

1. Pull a List of Projects That Do Have the Task

   • Create a new Task Report, add a filter rule: Task Name > Equals > Identify External Resources.
   • Add the Project ID column to this report, then export the list of project IDs (you can copy-paste them directly from the report view too).

2. Filter Projects That Don’t Appear in That List

   • Create a new Project Report, add a filter rule: Project ID > Not In > [paste the list of project IDs from step 1].
   • Run the report—this will show all projects that aren’t associated with the "Identify External Resources" task.

Pro Tips for Accuracy #

• Exact vs. Partial Matches: If your task names have minor variations (e.g., extra spaces, capitalization), replace Equals with Contains in the EXISTS() function:

  IF(EXISTS(Tasks:Task Name CONTAINS "Identify External Resources"), "Yes", "No")
  

• Include Subprojects: If your projects have nested subprojects, modify the expression to scan subproject tasks too:

  IF(EXISTS(Tasks:Task Name="Identify External Resources", Include Subprojects=true), "Yes", "No")
  

• Permissions: Make sure you have view access to all tasks under the projects you’re scanning—if you can’t see a task, the EXISTS() function will treat it as missing even if it exists.

内容的提问来源于stack exchange，提问作者clj