What is the formula for RYGB to use for status i.e. Green for Complete, Red for At Risk,etc.,

I appreciate the help on this.  This is the formula that I am using:

=IF([Status]4=At Risk, "Red", IF([Status]4=Not Started, "Yellow", IF([Status]4= Complete,”Green”, IF([Status]4= In Progress "Blue",””))))

Best Answers

  • lupe.neukirch68876
    Answer ✓

    Andree- Thank you, thank you, thank you!  The second formula worked like a charm :)  This is most helpful

Answers

  • lupe.neukirch68876
    Answer ✓

    Andree- Thank you, thank you, thank you!  The second formula worked like a charm :)  This is most helpful

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Excellent!

    You're more than welcome!

    I'm always happy to help!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!