IF statement with a OR statement


I have a IF statement setup in a cell to look at another cell's value to trigger a status color using the RYG icon. I also have another column labeled Urgent with the "flag" icon. I would like if someone selects the flag in Urgent that the status is changed to red.

Current IF statement:

=IF(Calc1 > 1, "Green", IF(Calc1 < 0.75, "Red", "Yellow"))

I would like for this to be still in place with the addition of an OR statement that will make the status "Red" if someone clicks the flag

Any help would be greatly appreciated

Best Answer


  • PCC87
    PCC87 ✭✭

    Perfect Mike! Thanks for your help!

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Glad I could help. Please mark my post as best answer if it solved your issue! :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!