RYG Formula: Trigger Yellow within 2 of the Set Threshold

Anthony Barthelemy

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

Ramzi K

@Ray B

Ooops - I missed the obvious ...

=IF(AND([Story Points]@row >= ([Max Story Points]@row - 2), [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")))

Cheers,

Ramzi

Ramzi K

@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

Anthony Barthelemy

Error Received: #INVALID

Anthony Barthelemy

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

@Ray B

👍

Cheers,

Ramzi

Anthony Barthelemy

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?

Ramzi K

@Ray B

Ooops - I missed the obvious ...

=IF(AND([Story Points]@row >= ([Max Story Points]@row - 2), [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")))

Cheers,

Ramzi