Home › Forums › Discussion › Can't get amber status formula to work for current rag
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.
Mail (will not be published) (required):
Please complete this equation so we know you’re not a robot. 17 − 10 =
Please enter your username or email address. You will receive a link to create a new password via email.
Enter the destination URL
Or link to existing content