How to flag all tasks under a summary task?

[cbass1224]

Is there a formula that flags all summaries and tasks below a top level summary of a certain name or level?
Right now I can get one level down with [Task Summary Name]=”*”.

[Jerome Odeh]

Add a WBS column to your View.

Then add a Custom Field, say Text1 and add this formula to it and also use formula for Summary Rows.

IIf(InStr([WBS],”.”)=0,0,Left([WBS],InStr([WBS],”.”)-1))

This formula extracts the part of the WBS before the first decimal point.

Therefore assuming you want to show all tasks and summary rows under WBS 2, your filter will be Text1 equals 2

[cbass1224]

Thank you, sir! I will try this.

[Author]

Posts