RYG Formula: Trigger Yellow within 2 of the Set Threshold

Options

How can I Modify this Formula to Turn Yellow if Story Point is within 2 Points of the Max Story Points:


=IF([Story Points]@row = [Max Story Points]@row, "Yellow", IF([Story Points]@row < [Max Story Points]@row, "Green", IF([Story Points]@row > [Max Story Points]@row, "Red")))

Thanks

Best Answer

Answers

  • Ramzi K
    Ramzi K ✭✭✭✭✭
    Options

    @Ray B

    Try this:

    =IF([Story Points]@row =< ([Max Story Points]@row - 2), "Yellow", IF([Story Points]@row < [Max Story Points]@row, "Green", IF([Story Points]@row > [Max Story Points]@row, "Red")))

    Cheers,

    Ramzi

    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

    Feel free to email me: ramzi@cedartreeconsulting.com

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

  • Anthony Barthelemy
    Anthony Barthelemy ✭✭✭✭✭✭
    Options

    Error Received: #INVALID

  • Anthony Barthelemy
    Anthony Barthelemy ✭✭✭✭✭✭
    Options

    Figured it Out. The Symbols (Less Than Equal) were backwards


    =IF([Story Points]@row <= ([Max Story Points]@row - 2), "Yellow", IF([Story Points]@row < [Max Story Points]@row, "Green", IF([Story Points]@row > [Max Story Points]@row, "Red")))

  • Ramzi K
    Ramzi K ✭✭✭✭✭
    Options

    @Ray B

    👍

    Cheers,

    Ramzi

    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

    Feel free to email me: ramzi@cedartreeconsulting.com

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

  • Anthony Barthelemy
    Anthony Barthelemy ✭✭✭✭✭✭
    Options

    Something is not right. The RYG Column is Yellow based on the Criteria Below and it should not be Yellow.

    Story Point = 22

    Max Story Points =31

    Thoughts?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!