How to filter topics with task progress set to "None"?

  • 2
  • Question
  • Updated 3 years ago
  • Answered

In a large map, I'd like to be able to quickly query for topics which have their task progress set to "None".  In other words, I'm trying to flush out any stray tasks for which I've forgotten to set the task progress value.

I've looked at the Progress filter and Power Filter tools under the View tab, but it appears that those tools only can return results for which the task progress is set between 0 - 100%.  There does not seem to be any explicit option for searching for tasks with Progress set to "None".


Photo of Ashok Kumar

Ashok Kumar

  • 18 Posts
  • 1 Reply Like

Posted 4 years ago

  • 2
Photo of Nick Duffill

Nick Duffill, Champion

  • 527 Posts
  • 178 Reply Likes
I think this solution will show all topics that do not have a percent complete value. These topics may or may not be tasks. A task has at least one value set amongst the start date, due date, priority, resource or duration. I could not see a way to access this status through the Power Filter, but it can be done with a macro. If you are able to use macros, I have put up an example at

http://harportconsulting.com/wp-content/uploads/2015/11/Filter-partially-defined-tasks.zip

The macro filters-in all topics in the map that are tasks but do not have a percent-complete value. It selects them as well, so you can run it then apply a percent-complete marker from the Task Info pane. Comments and improvements welcome :)

Nick