Health indicator (colors) formula in the WBS Configuration template?

System

This discussion was created from comments split from: Work Breakdown Structure (WBS) - Column Formula Configuration.

divyaj22

I'm very new to Smartsheet formulas. Can someone please explain the Health indicator (colors) formula in the WBS Configuration template?

dojones

This is the formula.

=IF(ISBLANK([Start Date]@row), "", IFERROR((IF(OR([Start Date]@row = "", [Start Date]@row > TODAY()), "Gray", IF(OR([% Complete]@row = 1, [End Date]@row > TODAY(3)), "Green", IF([End Date]@row < TODAY(), "Red", IF(NETWORKDAYS(TODAY(), [End Date]@row) < 3, "Yellow", "Green"))))), ""))

Gray = Start Date > Today

Green = 100% Complete or End Date > 3 days from today

Red = End Date < Today

Yellow = < 3 workdays from End Date