Help with nested If, Then Statement


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!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!