Loading...
Quick Links

Can't get amber status formula to work for current rag

Home Forums Discussion Can't get amber status formula to work for current rag

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #391023 Reply
    Marcelina T
    Guest

    Using the following formula, I am attempting to return an amber status.

    IIf([Baseline Finish]<>ProjDateValue(‘NA’), IIf(([Finish]>[Baseline Finish] And ([Finish]<=[Late Finish])) OR (ProjDateDiff([Baseline Finish],[Project Calendar])/480 >1 and ProjDateDiff([Baseline Finish],[Project Calendar])/480 < 6),1,0),0)

    However, it clears the whole column of data and only returns completed tasks in the current rag status column.

    I’m at a loss of what could be the cause.

    I’m using project standard on a windows machine with 8GB RAM & Windows 10 running.

    Any help will be greatly received.

    Thanks

    MT.

Viewing 1 post (of 1 total)
Reply To: Can't get amber status formula to work for current rag
Your information:




17 − 10 =