Filter to show Summary task

Home Forums Discussion Forum Filter to show Summary task

Viewing 3 reply threads
  • Author
    Posts
    • #501848
      Thomas John
      Guest

      Hi MS Project experts,
      I would like to create a filter / view in which it should reflect all tasks with their summary tasks that are less than 100%. All summary tasks that are 100% should be minimized and should not display the child tasks in that view.

      All summary with 100% complete should be minimized
      All summary less than 100% should display all child tasks.

      If somebody can help, to know if a formula can be created for this request or a vba macro and how to do it. Thanks

      Thomas John

    • #506711
      albertmay
      Participant

      That is the only task I should have had to do the last couple of days and I also I’m looking for the freezer van rental because I’m in Dubai want to start freezer van business out of the city want to complete a business guide to take over new business.

    • #533829

      Is this what you need?
      https://imgur.com/VingRdzComplex filter
      The filter is:
      (% complete < 100%) OR (% complete = 100% AND summary = yes)
      To insert the OR between the two sets of conditions, you simply select the AND/OR column and enter OR and then select the row below to start entering the second set of conditions.

    • #533830

      I’ll try again with the image!
      Complex filter

Viewing 3 reply threads
  • You must be logged in to reply to this topic.