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

[Marcelina T]

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.

[Author]

Posts