IF statement with a OR statement

Options

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

Answers

  • PCC87
    PCC87 ✭✭
    Options

    Perfect Mike! Thanks for your help!

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    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!