Display entered values only in a Values SmartColumn

One function of the Values SmartColumn is to display user-entered numbers.

Create a Values SmartColumn that displays entered values, only:

  1. Choose Insert | Rows, Columns | New Column | Values.

  2. The Indicators for Values Column window appears.

  3. Values display options:Values display options:

    • Show result as a percent  (.35 becomes .35 x 100 = 35%).

    • When shown on Summary Bar, show average. The summary row values will be an average of lower-level values instead of a sum.

    • Just add a % sign after value. A % is added to the value (35 becomes 35%).

    • On Summary Rows show value in cell. Use this to override summary row values (which are normally sums or averages of lower-level values) with user-entered summary row values.

    • Automatic EV BCWS calculation is based on Baseline Dates (if possible). to assign the earned value calculation to baseline symbols in the schedule.

    • Interpret column value as a Julian date and display as a date.

      • This setting makes it possible to designate that a column of numbers can be displayed as dates. For example, 4/9/2009 has a Julian value of 733500 (which is 733,500 days after the first day of year 1.) When date SmartColumns are used in calculations, they are first converted to their Julian date, so if the result is also a Julian date the result should be displayed as a date, then use this option. Values less than 1 and more than 2,000,000 are ignored.  

    • Display resultant value as a Duration. Converts values entered into duration values.  This feature is needed to import duration values from an XML file.

  4. Click OK.

  5. Under the Column Heading tab, enter a title for the column.

  6. Under the Column Formatting tab, make currency, alignment, and other selections.

Enter values in the Values SmartColumn:

Typically, values should be entered at the lowest outline level. Values can then be automatically summed on the summary levels.

  1. Click  (the toolbox Text tool.)

  2. Click once in a column cell.

  3. Enter the numerical value.

  4. Use the up-arrow and down-arrow keys on the keyboard to move from cell to cell.

 

 

Related Topics

  1. Override_summary_row_values
  2. Show_average_on_summary_row
  3. Values SmartColumn
  4. Values SmartColumn: Display indicators based on numbers or text in another column
  5. Values SmartColumn: Display entered values, only

 

  

Guided Help Home

 

 

 

 

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.