Custom stoplight column

Question:     

We would like to create a SmartColumn using a column (Number4) from Microsoft Project using the following user-defined values ranges to display values, symbols, text and colors.

  • Green: < 5%
  • Yellow: > 5% < 10%
  • Red: > 10%

 

Answer:

You should set up a Values SmartColumn with a column tag for the Number column to be refreshed.  Then, customize the settings to display the colored indicator based on the number.

Insert | New Column | Values.

Customize the indicators to match what is shown here.

 


 

Related topics

Stoplight SmartColumn (Milestones Help)

Custom date formats

Date format and importing from Excel

Symbol date format

International date formats

 

 

 

 

 

Applies to Milestones Professional:      2019        2021        2023        2025

 

 

 

 

      

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

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