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

Options

Answers

  • divyaj22
    Options

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

  • dojones
    dojones ✭✭✭✭
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!