Question:
How can I display symbols to indicate which tasks are, for example, 50%, 75%, 90% complete? I want to show which tasks are complete, which ones haven't started and so on.
|
Answer:
To do this, you need to create two columns: a Percent Complete SmartColumn and a Values SmartColumn which will display symbols according to the percent complete column values.
(See the sample schedule below.)
(Note: another possibility is to show a % Complete (Pie) Indicator in the % Complete Column.)
Step A: Add two columns
-
Choose New Column on the Insert menu.
-
Choose Percent Complete... from the list of column types
-
Configure the Percent Complete column and click OK.
-
Choose New Column on the Insert menu.
-
Choose Values... from the list of column types.
Step B: Define the Values SmartColumn that will display the indicator symbols
-
Double-click the column heading of what will be the Values SmartColumn.
-
Enter a column name.
-
Choose the Column Type (SmartColumn) Settings tab.
-
For SmartColumn Definition, choose Values.
-
For Column to Compare, choose the percent complete column.
-
Un-check Display numerical value also.
-
Choose Pick indicator symbology based upon the following conditions.
-
Click the drop-down arrow to choose which and when symbols appear.
-
After you choose a symbol, choose Condition is based upon the value in a cell.
-
Enter a value range for each symbol. See the sample ranges, above.
-
Choose OK to return to the schedule.
Below is the resulting schedule.
|
2017