IF Logic for Symbols

Ronnie S. · 01/26/23

Hello,

I am trying to run a IF logic statement under the "Health" column to yield a symbol if certain conditions are met.

If % Budget vs % Work Complete is between -15% AND -11%, then symbol should be 'Yellow' circle

If % Budget vs % Work Complete is less than -15%, then symbol should be 'Red' circle

Paul Newcome · 01/26/23

Try this:

=IF([% Budget vs % Work Complete]@row< -0.15, "Red", IF([% Budget vs % Work Complete]@row<= -0.11, "Yellow"))

Paul Newcome · 01/26/23

Try this:

=IF([% Budget vs % Work Complete]@row< -0.15, "Red", IF([% Budget vs % Work Complete]@row<= -0.11, "Yellow"))

Ronnie S. · 01/26/23

Thank you, Paul. That worked! Appreciate your help.

Paul Newcome · 01/26/23

Happy to help. 👍️

Smartsheet Basics