Struggling with an IF formula I feel should be simple.

LucyS

What I am trying to do is this:

If the Status is Satisfied, Health is Green

If the Status is Concerned, Health is Yellow

If the Status is At Risk, Health is Red

Tried: =IF(Status = "Satisfied", "Green", IF(Status = "Concerned", "Yellow", IF(Status = "At Risk", "Red")))

 

Genevieve P.

Hi @LucyS

You're just missing the row reference after the column reference. You're looking in the Status column, but what row?

Try using the @row feature to indicate you're looking in this current row:

Tried: =IF(Status@row = "Satisfied", "Green", IF(Status@row = "Concerned", "Yellow", IF(Status@row = "At Risk", "Red")))

See: Create a Cell or Column Reference in a Formula

Let us know if that works for you!

Cheers,

Genevieve

Paul Newcome

That should be working, and it appears to be working in your screenshot. Are you getting an error, or is it outputting the wrong color?

LucyS

Sorry - the colors were manually entered - trying to add formula so when someone changes the status the health changes. When I add the formula I get #UNPARSEABLE.

Paul Newcome

Everything looks good in your posted formula. The only thing I can think of is that maybe you are in a region that uses semi-colons instead of commas. Try swapping them out and see if that works for you.

LucyS

Unfortunately that did not work either. At least it's not just me - I was sure I was making a rookie error.

Genevieve P.

Hi @LucyS

You're just missing the row reference after the column reference. You're looking in the Status column, but what row?

Try using the @row feature to indicate you're looking in this current row:

Tried: =IF(Status@row = "Satisfied", "Green", IF(Status@row = "Concerned", "Yellow", IF(Status@row = "At Risk", "Red")))

See: Create a Cell or Column Reference in a Formula

Let us know if that works for you!

Cheers,

Genevieve

LucyS

Yes - this worked! Thank you so much!

Genevieve P.

No problem! I'm glad we found what the issue was 🕵️

Paul Newcome

Thank you @Genevieve P. 🤦‍♂️