AND IF in conditional column

[jsaue003]

Hello.

I have three columns with health values (Scope Health, Schedule Health, Budget Health) and four category columns which are supposed to be populated with Path to Green if any of the three columns with health values are other than green. I've tried a custom column with the following: 

if [Scope Health] <> "Green" or [Schedule Health] <> "Green" or [Budget Health] <> "Green" 

AND 

[Category 1] <> "Path to Green" or [Category 2] <> "Path to Green" or [Category 3] <> "Path to Green"or [Category 4] <> "Path to Green" 

THEN "Yes"

No matter what I swap around I can't get this to say "Yes" correctly. The function itself gives me errors (token THEN expected). How can I achieve this? 

[Greg_Deckler · Accepted solution]

I believe you want this:

if ([Scope Health] <> "Green" or [Schedule Health] <> "Green" or [Budget Health] <> "Green") and [Category 1] <> "Path to Green" or [Category 2] <> "Path to Green" or [Category 3 <> "Path to Green" or [Category 4] <> "Path to Green" then "Yes" else "No"