IF Formula issues

Options

I am essentially trying to combine 2 stoplight conditions into 1. I'm trying to have the formula express that if both the Min and Mix column are gray, then populate a gray dot. If either column is red, then red dot. And finally if both columns are green, then green. Is this possible?

Answers

  • AKrebel
    AKrebel ✭✭✭
    Options

    Formula:


    =IF(AND([Slip Torque Min Status]@row = "Gray", [Slip Torque Max Status]@row = "Gray", "Gray", IF([Slip Torque Min Status]@row = "Red", "Red", IF([Slip Torque Max Status]@row = "Red", "Red", IF([Slip Torque Min Status]@row = "Green", "Green", IF([Slip Torque Max Status]@row = "Green", "Green"))))))

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Options

    Are you getting an error or is it not outputting the correct color? The formula in your screenshot looks like it should be working. The formula you pasted in your comment is missing a closing parenthesis to close out the AND statement.