Forum Discussion
Solved
Custom field calculation not working perfectly
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?
- 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
5 Replies
- 23dV2095,
Try using the Current Date field instead of Now.
John- Thanks, I've changed it, will check tomorrow to see if it works.
- 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",""))
IgnacioThanks, I've changed it, will check tomorrow to see if it works.
- It worked perfectly. Thank you
