Struggling with an IF formula I feel should be simple.
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")))
Best Answer
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
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?
-
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.
-
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.
-
Unfortunately that did not work either. At least it's not just me - I was sure I was making a rookie error.
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Yes - this worked! Thank you so much!
-
No problem! I'm glad we found what the issue was 🕵️
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!