If status is open and risk is high then X
I'm trying to create a formula that references two columns (Status and Risk Rating) to display the "no", "hold" or "yes" symbols. If the Status row is open AND the Risk Rating is High/Medium/Low, etc... I have the formula to work if I am just referencing risk rating IF([Risk Rating]@row = "High", "No", IF([Risk Rating]@row = "Medium", "Hold", IF([Risk Rating]@row = "Low", "Yes"))
I would think the formula would be =IF(AND([Status]@row = "Open", ([Risk Rating]@row = "High", "No" and so on... but it gives me the unparseable error any advice?
Answers

The formula is the right one you just have to Close the and statement before you finish the If Statement. See Below
=IF(AND([Risk Rating]@row = "High", Staus@row = "Open"), "No", "")

You don't need the AND() function.
Your IF() statement for evaluating risk_rating (corrected) is
IF([Risk Rating]@row = "High", "No", IF([Risk Rating]@row = "Medium", "Hold", IF([Risk Rating]@row = "Low", "Yes")))
...which works just fine.
You're adding one more condition when Status is 'Open' so the structure of your formula would look like this...
IF( [Status]@row = "Open", your_statement_for_risk_rating , value_for_when_status_not_open )

Thank you so much!
Help Article Resources
Categories
Check out the Formula Handbook template!