Resources, Durations and Planned Hours are Blank for Sub-Task

Forum|Forum|2 years ago
August 21, 2023
2 replies
1017 views

Hi Community,

I'm trying to create a report to pull sub-tasks with Blank resources, or Durations or Planned hours. The purpose of this report is to ensure project owners or PMs don't leave any sub-task blank during project planning.

Below (screenshot) is the report I created but is not working as expected, is pulling parent task and sometimes it does NOT pull sub-task that has no resources, or durations or planned hours.

Any help on what filters to apply will be much appreciated.

Thanks

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Ryzan99

Hi. Have you tried including "Task > Number of Children" within both the first and last logic? Since you're using an OR statement, you also need to include the same filter (Task > Number of Children) in the other logic. Please refer to the example screenshot. I hope this solution helps you.

R

Ryzan99Accepted solution

Level 2

Hi. Have you tried including "Task > Number of Children" within both the first and last logic? Since you're using an OR statement, you also need to include the same filter (Task > Number of Children) in the other logic. Please refer to the example screenshot. I hope this solution helps you.

M

meshackOmAuthor

Level 3

Thank you so much @ryzan99 and @kundanism , your input was very valuable and it works. Please see the filters I used as per your input. Your help is super appreciated.