two factor RGB balls formula. Status and Date

Options

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

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓
    Options

    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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!