Sort by dollar values in columns

Question:     

I need to sort tasks by dollar amount and dollar categories.  How is this done?

 

Answer:

You can sort dollar amounts in ascending or descending order:

  1. On the Tools tab, choose By Multiple Columns in the Sort section.

  2. Select the Sort Order as descending or ascending

  3. Check First Key Column

  4. Choose the name of the column containing the dollar values

  5. Choose Currency, then OK  

 


You can also filter-out dollar amounts of a certain value range:

 

  1. On the Tools tab choose, choose Filter task rows

  2. For Type of Filter, choose Numbers in column greater than or ..less than

  3. Enter a number

  4. Check Treat numbers as currency, then OK

 

If you have lots of columns with values, you might want to highlight that column first (move cursor to lower part of column heading cell and click once).

 

 

 

 

 

 

 

 


 

 

Related topics

Sort by name

Filter by symbols and date range

Filter to bring in just part of a Microsoft Project plan

Filter to remove tasks which are 100% complete from view

Find a string in one of my Milestones files

Sort task rows (Milestones Help)

 

 

 

 

 

 

 

 

Applies to Milestones Professional:      2019        2021        2023

 

 

 

 

      

The fast easy way to schedule your projects:  Milestones Software by KIDASA Software, Inc. www.kidasa.com

Copyright © 2023 KIDASA Software, Inc. All rights reserved.