Percentage in a formula

Hi,

Happy New Year!

I got stuck with what I thought was a simple formula and I'm hoping you can help me.

We have three different thresholds that I need to use to change the RYG balls:

Above 3% - Red

Between 0 and 3% - Yellow

Below 0% - Green

My formula looks as below:

=IF(ISBLANK(Slippage@row), "", IF(Slippage@row > 0.3, "Red", IF(Slippage@row >= 0, "Yellow", IF(Slippage@row < 0, "Green"))))

It does not work with "Red" at all. I only see yellow and green balls.

Can you help please?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!