Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!
SOLVED

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

Avatar

Level 3

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 

meshackOm_0-1692576141724.png

 

 

1 Accepted Solution

Avatar

Correct answer by
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.

 

Example.png

View solution in original post

5 Replies

Avatar

Correct answer by
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.

 

Example.png

Avatar

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. 

 

meshackOm_0-1692753825467.png

 

Regards,

Mesh 

Avatar

Level 10

May be you can try this one. Please refer the attachment. Believe matches your requirement criteria.