two factor RGB balls formula. Status and Date

J.Barrow

I know this has been asked a million times and I have looked at all the other post, but still cant get it to work.

Status options are:

Not Started

In Progress

Completed

Transferred To Other Department

Due date is standard date format

I am trying this as the formula:

=IF(Status@row = "Transferred To Other Department", "Green", IF(Status@row = "Complete", "Green", IF([Response/ Resolution Deadline]@row - TODAY() < 0, "Red", IF([Response/ Resolution Deadline]@row - TODAY() <= +5, "Yellow", "Green",))))

I know I am just missing something but I cant figure it out.

Jamie

Kelly Moore

Hey @J.Barrow

Is the problem an UNPARSEABLE error? There is an extra comma after your last Green. If this is not the problem, please help us understand if it's an error (what error?) or an unexpected result (what result and what was expected).

Kelly

Kelly Moore

Hey @J.Barrow

Is the problem an UNPARSEABLE error? There is an extra comma after your last Green. If this is not the problem, please help us understand if it's an error (what error?) or an unexpected result (what result and what was expected).

Kelly

J.Barrow

Well yes it was part of the problem, but now it still is going red even when things are marked completed or moved to another department when they should be green.

J.Barrow

Oops I found the problem the Completed was complete