RYG Formula Green Error

Kaleb

Smartsheet Community:

Can Someone Take a Look at my Formula and See Why I am Getting Yellow when Budget + / - is 0? I Should be Receiving Green Indicator.

Formula:

=IF([Budget + / -]@row >= 0, "Green", IF([Budget + / -]@row < -0.05, "Red", "Yellow"))

Thanks

Kaleb

Disregard Smartsheet Community I Found The Issue. The Plan Vs Actual Columns Result in Decimals. This is Causing The Budget be Negative by a tenth

Andrée Starå

Hi @Kaleb

I hope you're well and safe!

Excellent! Glad you got it working!

Be safe, and have a fantastic weekend!

Best,

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

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!