Custom field calculation not working perfectly

[23dV2095]

Microsoft Project Standard 2016

Custom text field

Formula:

IIf([% Complete]<> 100 And [Scheduled Finish]<Now(),"Late",IIf([% Complete]<>100 And [Scheduled Finish]-Now()<15,"Due:,""))

If % complete not equal to 100% and scheduled finish is in the past, then display "Late"

If % complete not equal to 100% and scheduled finish is less than 15 days in the future, then display "Due"

Formula works fine. However, if I open the file it does not recalculate (as the definition of Now() is likely different). Changing the duration of any incomplete tax causes recalculation properly.

Is there a way to make this recalculation occur whenever the file is opened?

[#2 · Accepted solution]

Hi Dan.

Try [Current Date] field instead of Now()

The formula would look like this:

IIf([% Complete]<>100 And [Scheduled Finish]<[Current Date],"Late",IIf([% Complete]<>100 And [Scheduled Finish]-[Current Date]<15,"Due",""))

Ignacio

[#3]

23dV2095,
Try using the Current Date field instead of Now.

John

[#4]

@Ignacio_Martín 

Thanks, I've changed it, will check tomorrow to see if it works.

[#5]

Thanks, I've changed it, will check tomorrow to see if it works.

[#6]

It worked perfectly. Thank you