two factor RGB balls formula. Status and Date


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


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.


Best Answer

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

    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).



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!