Help with an IF OR function

Hi,

I am trying to write a formula that says that the status indicator in a column should turn red if either a) answer in drop down column is "No," or b) second column is NOT left blank (i.e., if someone adds information to the column). I have been able to get formulas for either of the two functions to work independently with just the IF fxn, but as soon as I try to string the two together with IF (OR..., I get either Unparseable error or Incorrect argument error. I think I must be off by a parenthesis or bracket or something. Any help would be appreciated!

Here's the formula I am using. Each argument as written works if used independently:


=IF(OR([Reviewed MD Agrees with Final Category]@row = "No", NOT(ISBLANK([Response by Reviewed Physician@row])), "Red"))


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!