Forum Discussion

23dV2095's avatar
23dV2095
Copper Contributor
Dec 19, 2023
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 % comp...
  • Ignacio_Martin's avatar
    Ignacio_Martin
    Dec 19, 2023
    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
23dV2095's avatar
23dV2095
Copper Contributor
Dec 19, 2023

Ignacio_Martin 

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

23dV2095's avatar
23dV2095
Copper Contributor
Dec 28, 2023
It worked perfectly. Thank you

Resources