Help with nested If, Then Statement

rmillar

Hi, I inherited Smartsheet templates from a staff member no longer with the organization and am trying to understand the formulas driving our metrics and dashboards.

A column formula was written to generate schedule risk as follows:

The sheet columns:

Can someone please help me understand the logic in plain speak? I want to understand the conditions for when Green, Yellow, Red or Blue symbol is generated in "Schedule Risk" column.

Thanks in advance for your help!

Ryan

Joe Goetschel

Looks like this is what it does.

Blue if Complete status or if it's Blank ("")

Red if the end date is in the past

Yellow if the end date is in 3 days

Otherwise it is green

I think I read that right.