How to Set scheduled status lights in the MS project.

Two days ago, it was required to set a plan status light in the MS Project to clearly view the current situation of a plan.

The procedure is as follows:

In the tool, call the enterprise Template

In the tool, set a custom Enterprise Domain

Set the formula for this column

Set this column as the image display mode and define the Image Display rules.



I made a tutorial file and didn't put it up. You can send me an email if you need it.

Status	Display light	Return Value
Pause	Gray light	0
Expire in three days	Bulb	1
Completed in advance	Blue light	2
Completed on time	Green light	3
Extended within 6 days	Yellow light	4
Extended for more than 6 days	Red light	5
		-1

Other Instructions

Projdatediff ([baseline finish], date ()/480 = current date-number of days of the baseline completion date

What is the data obtained by isdate ([actual finish])-1?

If the value of actual finish is Na, The isnull () function check is still 0;

If you do not save the benchmark time, an error occurs. (Note: Baseline finish (baseline time) determined ))

The formula is as follows:

IIF (CSTR ([% work complete]) <> '123 ',

IIF ([baseline finish]> date (), IIF (projdatediff (date (), [baseline finish])/480 <=,-1),-1 ),

IIF ([actual finish] <[baseline finish],

2,

IIF (projdatediff ([baseline finish], [actual finish])/480 = 0,

3,

IIF (projdatediff (date (), [actual finish])/480 <= 6, 4, 5)

)

)

)