Help with an IF OR function

Vaibhav Khasgiwala

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"))

IF OR Formula Problem SS.jpg

Vaibhav Khasgiwala

It worked! Thank you!!

Paul Newcome

You just have a misplaced parenthesis...

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

Vaibhav Khasgiwala

Hi Paul!

Thanks for the response. I pasted the above and it's still giving me an unparseable error :(

Paul Newcome

I had just copy/pasted to move things around and din't notice that there is a square bracket out of place. Try this one...

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

Vaibhav Khasgiwala

It worked! Thank you!!

Paul Newcome

Happy to help. 👍️