Project 2010: Introducing AutoFilter
In Project 2010, we made a big update to AutoFilter in the client. Now from the column header you can sort, filter on, and group by the field. Essentially there are four zones:
Sorting: Depending on the type of field, you can sort alphabetically, numerically, or chronologically. Group By: You can select to group explicitly on the field, or group on an interval specific to the field type. For example, for date fields this looks like: If you aren’t sure why to use group by, check out this post. Filters: While you can easily use the checkboxes to select which values to display, the filter flyout allows you to do this more quickly based on the selected criteria. Date Fields: Duration Fields: Checkboxes: These allow you to select which values to display by simply checking/un-checking the values. For example, if I uncheck October then none of the task that start in October will be displayed. |
AutoFilter is on by default in Project 2010. If you aren’t seeing it, you can turn it on by going to View tab – Filter dropdown – and selecting Display AutoFilter.
You can tell an AutoFilter is applied since the column header displays the funnel shape . Additionally, the Status Bar displays “AutoFilter Applied” and if you hover over it, you can see which fields are affected:
Comments
Anonymous
February 10, 2010
Thanks for these articles, I enjoyed them!Anonymous
February 12, 2010
Just received the program and have only had time to scan the features. I was impressed having used simular Managers in the Construction Industry. My plans for using this program in the near future is to the development of Business start up & continuous momentum schedules. Will let you know how I get on. Regards, Karl karlturk@live.com.auAnonymous
May 13, 2010
Hi there, If someone applies autofilter on one of the columns and then hides that column. How can I find which column the filter was applied on?Anonymous
May 14, 2010
You have 2 options - when an autofiltered is applied, the status bar says "AutoFilter Applied", you can then hover over this text and the tooltip will show you which columns the autofilter is applied to. The second option is that you can go to the Task Name autofilter dropdown and select "Clear All Filters", this will remove filters from all of the columns they are currently applied to.Anonymous
October 27, 2010
I am interested in purchasing project 2010 but need further advice on the templates to all allow transfer of information from my accounting software. If there is a company in Melbourne Australia that has the knowledge to help please let me know.Anonymous
September 01, 2011
Could someone please tell me how to sort on two columns at once? For instance, one custom field has number, and another has task names. I want to sort by number, then alphabetically within number. How do I do the second sort? Thank you.Anonymous
September 01, 2011
To sort on more than one field, go to View tab - Sort - Sort By and then you can define the sort order you mention.